XL XP Custom Functions 1

[vaneagle]

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

 

[Zathras]

Take a look at Application.Volatile

 

[vaneagle]

Hi Zathras.

Spot on!! Have a star!!

thanks,

vaneagle