Is there a VBA equivalent to the Excel Functions Large/Small and Max/Min?
B BillCPA Oct 18, 2004 #3 Thank you very much! Bob Phillips said: worksheetfunction.max(range("A1:A3")) -- HTH RP Click to expand...
Thank you very much! Bob Phillips said: worksheetfunction.max(range("A1:A3")) -- HTH RP Click to expand...
M Myrna Larson Oct 19, 2004 #4 Most worksheet functions can be used from VBA, as Bob points out. Exceptions are those functions for which VBA has its own version.
Most worksheet functions can be used from VBA, as Bob points out. Exceptions are those functions for which VBA has its own version.