I think you'll need to provide some more details.

Are all 200 sheets in the same workbook? Are the formulas the same from one
sheet to the next? Are the formulas located in the same cell(s) from on
sheet to the next? What are the formulas now, and what should they be?

If the formulas are identical between sheets and located in the same cells,
you can select multiple sheets at a time by holding down the Control key and
selecting multiple sheets w/your mouse. Then, whatever you type in one sheet
will be entered in all of the sheets selected.

Before trying any suggestions - make a copy of your file. If it's really
important - make several copies.



" wrote:

Ok, I've got about 200 spreadsheets with data at the top and formulas
at the bottom. All of these spreadsheets are identical in format. The
problem is that many of the formulas at the bottom were coded wrong and
I want to fix all 200 spreadsheets using a macro. The data at the top
of the spreadsheets is correct, I just need to change the formulas.
What is the best way to do this?

-Steve

PS: Sorry to ask such a basic question but I don't want to get fired on
Monday so what do I have to lose?