Changing Multiple Formulas

  • Thread starter Thread starter stevieboy1313
  • Start date Start date
S

stevieboy1313

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.
 
Back
Top