Using cell names across multiple worksheets

  • Thread starter Thread starter M.Boone
  • Start date Start date
M

M.Boone

I have multiple worksheets that have the same layout and I want to name
certain cells to make calculations easier. When I try to do this, I get a
message that the name is not unique. Is there any way to get around this? I
want to create a template for future worksheets.
 
Named ranges fall into two categories. Global and Local. Local names are
sheet specific. An example would be Print_Area. When you define a print area
XL creates a local named range on that sheet called Print_Area. Each sheet in
your workbook can have a local print area named range. To create a locally
defined named range use
'Sheet1'!MyName
instead of just
MyName

MyName can be duplicated on each sheet in the workbook. There are scope
issues when you are refering to these named ranges.
 
Thank you : ) I rather feel like an idiot since I also figured out I was
using the same name as a column (TT).
 
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?
 
Back
Top