Copying Named Ranges/Cells
Posted by Jill-ann on April 25, 2000 4:56 PM
I have a worksheet that includes about 50 named ranges. The first three letters of each range indicates the City for which the worksheet is used. I want to copy that worksheet and just change the name. However, the only way I've found to change the name of these ranges is to add a new name and delete the old one. There has got to be a faster way! (I'll be using this for about 15 cities. Can anyone teach me a quicker method??????? Thanks!