| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refreshing custom function
Stupid question, but anyway - I tested my function, and it had some errors.
Any time I made some changes to VBA code, function didn't refreshed in Worksheet so I had to write a function again in the cell. How can I avoid this, so result will change in the cell anytime I change a function in VBA? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
refreshing custom function
In the first line of the function put
Application.Volatile Put error handling in your function as well. -- Regards, Tom Ogilvy "Juggernnath" wrote in message ... Stupid question, but anyway - I tested my function, and it had some errors. Any time I made some changes to VBA code, function didn't refreshed in Worksheet so I had to write a function again in the cell. How can I avoid this, so result will change in the cell anytime I change a function in VBA? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function Values Not Refreshing | Excel Worksheet Functions | |||
| Refreshing external data breaks sorting of function columns | Excel Discussion (Misc queries) | |||
| Refreshing a User Defined Function | Excel Discussion (Misc queries) | |||
| Web Services function call and data refreshing | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Linear Mode
