Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command for recalculating macros
Hello,
I've written a function in a module that takes in as inputs some values from my spreadsheet and outputs a value. Now if change these input values on my spreadsheet, my macro deosn't automatically recalculate. Is there a function that recalculates function macros? Thanks, Naresh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command for recalculating macros
Hi Naresh,
excel will recalculate your function if all the input values are specified as arguments. But if you refer directly to cells in the body of the function excel will not recalculate it. see http://www.decisionmodels.com/calcsecretsj.htm for more info. Charles ______________________ Decision Models FastExcel Version 2 now available. www.DecisionModels.com/FxlV2WhatsNew.htm "Naresh" wrote in message ... Hello, I've written a function in a module that takes in as inputs some values from my spreadsheet and outputs a value. Now if change these input values on my spreadsheet, my macro deosn't automatically recalculate. Is there a function that recalculates function macros? Thanks, Naresh |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command for recalculating macros
Thanks very much, Charles. Ctrl-Alt-F9 was it. You've got
a great website. Naresh -----Original Message----- Hi Naresh, excel will recalculate your function if all the input values are specified as arguments. But if you refer directly to cells in the body of the function excel will not recalculate it. see http://www.decisionmodels.com/calcsecretsj.htm for more info. Charles ______________________ Decision Models FastExcel Version 2 now available. www.DecisionModels.com/FxlV2WhatsNew.htm "Naresh" wrote in message ... Hello, I've written a function in a module that takes in as inputs some values from my spreadsheet and outputs a value. Now if change these input values on my spreadsheet, my macro deosn't automatically recalculate. Is there a function that recalculates function macros? Thanks, Naresh . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command for recalculating macros
See the function
Application.Volatile /Niklas -----Original Message----- Hello, I've written a function in a module that takes in as inputs some values from my spreadsheet and outputs a value. Now if change these input values on my spreadsheet, my macro deosn't automatically recalculate. Is there a function that recalculates function macros? Thanks, Naresh . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use Windows command within Excel macros | Excel Discussion (Misc queries) | |||
Macros and Menu Command | Excel Discussion (Misc queries) | |||
Two Macros under One command button | Excel Discussion (Misc queries) | |||
macros from command line | Excel Discussion (Misc queries) | |||
Command buttons & macros | Excel Discussion (Misc queries) |