We are working with some pretty good size worksheets that have multiple
formulas. How can I change a reference in several formulas all at once,
without changing the rest of the formula? For example, I have one formula
that reads;
=COUNT(EV29:EV268),
and then we have =IF(EW12=0,"-",IF(EW12=1,0,STDEV(EW29:EW258)))
and =IF(COUNT(EW29:EW258)=0,"-",MAX(EW29:EW258)) just to name a few.

How can I change all of the formulas on the sheet to reference row 268?

Select all cells with formulasedit replaceew258 with ew268. Or use a macro
that also tests for only formulas.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"stevieboy1313" wrote in message
...
We are working with some pretty good size worksheets that have multiple
formulas. How can I change a reference in several formulas all at once,
without changing the rest of the formula? For example, I have one formula
that reads;
=COUNT(EV29:EV268),
and then we have =IF(EW12=0,"-",IF(EW12=1,0,STDEV(EW29:EW258)))
and =IF(COUNT(EW29:EW258)=0,"-",MAX(EW29:EW258)) just to name a few.

How can I change all of the formulas on the sheet to reference row 268?