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? |
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? |
All times are GMT +1. The time now is 07:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com