If the certain values are the same across all 180 sheets you could loop
through the sheets with one macro.

Provide some details on your data layout.


Gord Dibben MS Excel MVP

On Tue, 2 Dec 2008 04:31:00 -0800, fvs
wrote:

I have to replace certain values in a spreadsheet which then gives me new
calculated values. But the thing is I have to do this for 180 other
worksheets. Is it possible to create a macro substituting the values and
retrieving them. And then repating the process for the other 179?