View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ibeetb ibeetb is offline
external usenet poster
 
Posts: 67
Default 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/
------------------------------------------------