Excel formula in macro
 

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



------------------------------------------------
Message posted from http://www.ExcelTip.com/

-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
-- Hundreds of free MS Excel tips, tricks and solutions at http://www.ExcelTip.com/
------------------------------------------------

Excel formula in macro
 

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.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"johndoe" wrote in message
...
Hello,
Does anyone know how to preform an excel function from within a excel
macro. Thx



------------------------------------------------
Message posted from http://www.ExcelTip.com/

-- View and post Excel related usenet messages directly from
http://www.ExcelTip.com/forum
-- Hundreds of free MS Excel tips, tricks and solutions at
http://www.ExcelTip.com/
------------------------------------------------

Excel formula in macro
 

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

"johndoe" wrote in message
...
Hello,
Does anyone know how to preform an excel function from within a excel
macro. Thx



------------------------------------------------
Message posted from http://www.ExcelTip.com/

-- View and post Excel related usenet messages directly from
http://www.ExcelTip.com/forum
-- Hundreds of free MS Excel tips, tricks and solutions at
http://www.ExcelTip.com/
------------------------------------------------

Excel formula in macro
 

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
"Don Guillett" wrote in message
...
I do
application.vlookup(range("a1"),range("a2:x6"),2,0 )

"johndoe" wrote in message
...
Hello,
Does anyone know how to preform an excel function from within a excel
macro. Thx



------------------------------------------------
Message posted from http://www.ExcelTip.com/

-- View and post Excel related usenet messages directly from
http://www.ExcelTip.com/forum
-- Hundreds of free MS Excel tips, tricks and solutions at
http://www.ExcelTip.com/
------------------------------------------------