Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating Cells that Get Value from Macro
Hi.
I've written a VB macro that references a cell by name via the Range function. I call the macro from various cells in my spreadsheet. The value the macro returns becomes the value of the cell. I'd like the cells that use the macro to automatically update when the referenced cell value is changed. This is not happening. What do I need to do to get that to work? If it can't be done, is there a manual way to cause all cells on the worksheet to get refreshed all at once? As it stands, the only way I can update the cells is to go through them manually, one at a time, and click inside the formula bar for each one. I'm sure there must be a better way. Thanks for the better way :), Ken |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating links in a macro | Excel Discussion (Misc queries) | |||
Macro updating a new column each day | Excel Worksheet Functions | |||
Regarding auto updating Macro | Excel Discussion (Misc queries) | |||
Have a Macro run after updating cells | Excel Discussion (Misc queries) | |||
Macro for updating links | Excel Programming |