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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum If function 3
use of ADDRESS function within CELL function 4
Please help with vlookup function 4
Need help with DGET function 7
If function across sheets prints value of cell 4
Pivot Table Refresh option not able to see 1
VBA Countif across sheets? 5
Macro that runs when worksheet is automatically updated 2

Back
Top