Excel VBA function not refreshing

  • Thread starter Thread starter Charles Reyes
  • Start date Start date
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
 
Hi
you may try adding the line
application.vloatile
at the beginning of your UDF
 
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.
 
Back
Top