Use Find/Replace

Suppose we first enter:
=SUM(A1:A100)

and later define A1 thru A100 as alpha

Just Find A1:A100 and replace with alpha. All the formulas should get updated
--
Gary''s Student - gsnu200826


"Brad" wrote:


If a range is named after formulas has been created. What is an efficient
way to update the formulas?