Get a copy of name manager. It is the best tool out there for manageing named
ranges. It will allow you to swap names from global to local...

http://www.oaltd.co.uk/MVP/
--
HTH...

Jim Thomlinson


"M.Boone" wrote:

Ugh, me again.

I tried to create another named range and received the already exists error.
I entered the name as Template!BuyMU and 'Template'!BuyMU. I found where I
had used simply BuyMU (although it was listed as only having scope within
that worksheet) and attempted to change it to 'Work sheet'!BuyMU. Got the
same error. These are the only two places I've tried to use this name.
Suggestions?