Vacaut,

You can EVALUATE a string. Like this:

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

--
Ture Magnusson
Microsoft MVP - Excel
Karlstad, Sweden

"vacaut" wrote in message
...

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/