ExcelBanter - Recalculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Recalculation (https://www.excelbanter.com/excel-programming/299337-recalculation.html)

Anna[_6_]

Recalculation

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!

Frank Kabel

Recalculation

Hi
add the line
application.volatile
at the beginning of your function

--
Regards
Frank Kabel
Frankfurt, Germany

"Anna" schrieb im Newsbeitrag
...
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!

All times are GMT +1. The time now is 05:28 PM.