LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default Using cell names across multiple worksheets

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?




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i use the same cell name accross multiple tab names in a wo Paul Excel Discussion (Misc queries) 10 December 16th 08 02:35 PM
Formula - Capture Multiple names into One cell PSU35 New Users to Excel 5 September 9th 08 11:40 PM
How do I sort multiple names within one cell? Deborah P. in Charlotte Excel Worksheet Functions 2 October 10th 06 06:34 PM
Semi-automating the generation of multiple cell range names SJKopischke Excel Discussion (Misc queries) 4 June 23rd 06 06:04 PM
apply cell names to formulas in multiple worksheets BBurrows Excel Worksheet Functions 4 July 1st 05 05:35 PM


All times are GMT +1. The time now is 06:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"