Recalculation

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

Is there a VBA command (for use in Excel) that allows you
to carry out a function anytime the spreadsheet
recalculates? If so, please send the code.
Thanks!
 
Hi
add the line
application.volatile
at the beginning of your function
 
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

Active Cell problem 8
force recalculation of function 5
Recalculate a worksheet following an autofilter selection. 1
How to Determine When Calculations are Complete 3
controlling excel recalculation in VBA? 5
Selective Recalculate 2
How do I run code on startup before Excel re-calculates formulas? 7
empty arguments recalculation 2

Back
Top