Hi All,
I have a custom function in excel which I use. The issue is I am not sure how I go about updating/refreshing the calculation when the source data changes. With for example, sum(A1:A10), the sum function automatically refreshes... How do I go about doing the same thing with a function that sits in VBA? I need it to refresh once the data has been pasted into an area within a sheet.
Any ideas?
thanks in advance..
vaneagle
I have a custom function in excel which I use. The issue is I am not sure how I go about updating/refreshing the calculation when the source data changes. With for example, sum(A1:A10), the sum function automatically refreshes... How do I go about doing the same thing with a function that sits in VBA? I need it to refresh once the data has been pasted into an area within a sheet.
Any ideas?
thanks in advance..
vaneagle