updating formulas with range names
 

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

updating formulas with range names
 

Find & replace.

Press Ctrl+H, type what range it used to be (e.g. A1:A10), what range is now
called (e.g. MyRange) and choose either entire workbook or just sheet, and
click replace all.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Brad" wrote:


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

updating formulas with range names
 

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?