Excel formula in macro

[johndoe]

Hello,
Does anyone know how to preform an excel function from within a excel
macro. Thx



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at http://www.ExcelTip.com/
------------------------------------------------

 

[Chip Pearson]

It depends on exactly what you mean. You can call most Excel worksheet
functions with code like

Result = Application.WorksheetFunction.FunctionName(...)

Your post isn't clear about what you actually want to do.

 

[Don Guillett]

I do
application.vlookup(range("a1"),range("a2:x6"),2,0)

 

[ibeetb]

The easiest is application.worksheetfunction. and after you type the
dot, all the functions will appear.
Also, typing vba. will drop down the list of vba functions....that is vba
dot