Excel VBA function not refreshing

C

Charles Reyes

All,

I wrote some Public Functions that I am using in Sheet1.
I give the function a column name and a row number on
Sheet2, and it returns the value. Works fine, except when
I update the data on Sheet2. The function in Sheet1 does
not refresh. Is there a specifc command I should have as
part of my Sheet2 data load to tell Sheet1 to re-evaluate
all of its user defined functions? F9 didn't work.

Thanks,

Charles
 
F

Frank Kabel

Hi
you may try adding the line
application.vloatile
at the beginning of your UDF
 
D

Daniel.M

Hi Charles,

Make sure your function has the dependent cells part of its ARGUMENTS.
That's the only way Excel 'knows' it must recalc when a specific cell change.

Regards,

Daniel M.
 
Top