Edit named range

[fitz]

In Excel 2002, how do you edit the cell locations of a named range?

 

[Nick Hodge]

Fitz

Insert>Name...>Define

Select the name, amend it and press add again

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
web: www.excelusergroup.org