I have had problems with Max and Min functions in their application to arrays but nothing like this. The following line code strangely fails to identify the minimum value in a range (but corrrectly isolates the Maximum when Max is substituted for Min):
Sub FindMin()
set rng = Range("a1:d20")
Range("a:d").Find(WorksheetFunction.Min(rng)).select
End Sub
The above assumes that [a1:d20] is populated with values. For ... each loop can do the job but I prefer in this case the brevity of Find method.
Any ideas about the failure?
Bookmarks