Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting function into worksheet via macro | Excel Discussion (Misc queries) | |||
using the macro in Worksheet function | Excel Worksheet Functions | |||
worksheet function vs macro | Excel Discussion (Misc queries) | |||
macro or worksheet function? | Excel Worksheet Functions | |||
having 0 as a min when running mina or average | Excel Worksheet Functions |