Runtime error '1004' on one sheet while trying to change formulas to values

Good morning all!!

I'm trying to loop through all the worksheets in a workbook changing all the formulas to values. This works for 93 out of the 94 sheets in the workbook, but for some reason I am getting a runtime error '1004' application defined or object defined error on the 94th worksheet. I have no clue why. My code looks like this:

Please Login or Register  to view this content.

It does get halfway through the sheet turning formulas to values before stopping. When I get the error, it highlights the line .Value = .Value. Any help would be appreciated.

Dome

It looks like your macro should work properly. Can you attach a copy of your file?

Could you share what the problem was with us?