how is use worksheet function mina( ) in macro?

  • Thread starter Thread starter vacaut
  • Start date Start date
V

vacaut

I can only limited number of worksheetfunctions when I try to write
simple macro. How do I call some of the frequently used one such a
MinA() or SumA()
 
Vacaut,

You can EVALUATE a string. Like this:

Sub TestMinA()
Dim x
x = Application.Evaluate("=MINA(A1:A10)")
MsgBox x
End Sub
 
Back
Top