Sheets not auto calculating as expected!

[Snals]

Hi there!

I added two worksheets to an already written macros that uses the calculation method in excel to automatically calculate the sheets. It is supposed to automatically update the values in the cells that use the "getsnapvalue" function, however it doesn't work for the two new sheets I added. Any suggestions to what I could do to make it work? I don't know which part of the code to send so if you could let me know what else anyone needs to answer this question that would be great!

Thanks,

snals

 

[JoJ]

I am guessing you might need to add the code

Application.Volatile

in your getsnapvalue function.

 

[Snals]

Unfortunately I don't have access to the code written for getsnapvalue...I believe the macros is written and then each worksheet is set up using a template, where certain columns of cells have the formula (getsnapvalue) typed directly. Thanks very much though, JoJ, I'll keep plugging away at it!

snals