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 formulas>edit replace>ew258 with ew268. Or use a macro
that also tests for only formulas.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"stevieboy1313" <(E-Mail Removed)> wrote in message
news:823E9FF6-286F-4746-A3DA-(E-Mail Removed)...
> 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?