how is use worksheet function mina( ) in macro?
 

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

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

how is use worksheet function mina( ) in macro?
 

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/

how is use worksheet function mina( ) in macro?
 

it works. Thank you

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

how is use worksheet function mina( ) in macro?
 

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

--
Ture Magnusson
Microsoft MVP - Excel
Karlstad, Sweden
"vacaut" wrote in message
...

it works. Thank you.


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