Good morning,

I have a number (30 or so) of excel models that use the today() function in many tabs. Unfortunately, I will need to go through each of the models every week to archive them, and in order to do that I need a quick way of going through each model and replace the formula including today (maybe nested) with the correct hardcoded value. The formulae do not pop up in regular places within the sheets.

I can do pretty basic VBA but am at a loss as to what code I would write in order to automatically go through every tab of an open model to "freeze" the date.

Any help would be gratefully received.

Thanks
Will