Finding Smallest and Largest Value with VBA. Using ParamArray to find Minimum Value. Related Links: Remove Duplicates in a range, using “Find ‘Smallest’, ‘Largest’, ‘K-th Smallest’ and ‘K-th Largest’ Numbers in a Range, with Excel Functions. ———————————————————————————————– Contents: Determine smallest value in range Determine largest value in range Determine smallest value in each non-blank row...