Hello all,
This is my first time posting here and am glad to meet everyone. I am having a problem with a custom function that I wrote to return a double value based on worksheets that are in the workbook giving me a total. I wrote the function to be used in the sheets cells thinking that it would automatically update as the scenario's/numbers change but it only seems to update during certain changes and I don't know how to get it to fire off everytime there are changes.
Here is the code:
The following is the in cell formula that I give it to produce the numbers:
So the cells seem to update when I add new sheets to the workbook which is great but when I rename the workbook to the proper name it does not fire off the update in the calculation sheet. I can goto each cell that has that forumla in it and hit enter and it will update that individual cell but that's a royal pain in the **** :/
Any help or guidance with making it fire off when you rename a sheet updating the all of the forumulas would be great.
Thanks for your time,
TheChazm
Edit 1:
Also when I update the numbers from the source sheets manually it still does not update the calculations... dang :/
Bookmarks