Just a curious one here, I am trying to write what has turned into (for me) a very complex macro. I have the macro run through various subroutines. But this particular sheet also has a custom function that I wrote that is used within the spreadsheet to do a calculation, and this function is not called upon for this particular macro, yet at a certain point in the code it runs.
Is it because it is used as a formula within the sheet that it runs, or am I doing something wrong?
Kind regards
Rob
Upload Sample
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
You're not doing anything wrong - this is normal behaviour.
Everyone who confuses correlation and causation ends up dead.
Ok, here is the main Macro:
And here is the Function in a different module:
Please Login or Register to view this content.
Please Login or Register to view this content.
It will run if a cell that is referenced by the formula, either directly or indirectly, is changed.Originally Posted by Rob K
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
If at any point a sheet that has the function on it is calculated the function could be called.
So something in your main code must be triggering calculation.
If you don't want that to happen you could set calculation to manual at the start of the code.
Please Login or Register to view this content.
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks