| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ ------------------------------------------------ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ ------------------------------------------------ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ ------------------------------------------------ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ ------------------------------------------------ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro or Formula Question | Excel Worksheet Functions | |||
| Excel 2000 Formula or Macro | Excel Discussion (Misc queries) | |||
| Excel formula / Macro ? | Excel Discussion (Misc queries) | |||
| Excel formula - should this be a macro? | Excel Worksheet Functions | |||
| How do I set up a formula with a changing range in an excel macro | Excel Discussion (Misc queries) | |||
Linear Mode
