The attached file has a list of numeric constants in A1:A10. The VBA code in module Failure uses the Range.Find method to find the maximum value in this range but the result is Nothing. However, I wrote a small function that loops through the range and it correctly finds the desired value.
I have never seen this behavior for Find. Am I on double-secret probation and it won't work for me?
I have attached the file but for a quick look here is the code.
The output of this code is:Please Login or Register to view this content.
Using Find: not found!
Using FindValue: Found in $A$4
Bookmarks