how is use worksheet function mina( ) in macro?

[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()

 

[Ture Magnusson]

Vacaut,

You can EVALUATE a string. Like this:

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

 

[vacaut]

it works. Thank you

 

[Ture Magnusson]

You are welcome! I'm happy that I could be of assistance.