Define Names

  • Thread starter Thread starter Sheldon Wittlin
  • Start date Start date
S

Sheldon Wittlin

I have a work book with 12 different tab wirk sheets. I
want to define the same cell with the same name in each
sheet, so that when you are in a specific sheet and "GOTO"
the cell name it will reference that sheet. When you do
an Insert, Name, Define, it puts the cell name in but I
can not add the tab name to the "names in workbook"
section.
 
Try this Sheldon to give the range a1:a10 the name "ron"

Sub Give_name_on_all_sheets()
Dim Sh As Worksheet
For Each Sh In ThisWorkbook.Worksheets
Sh.Range("a1:a10").Name = Sh.Name & "!ron"
Next
Sheets(1).Select
End Sub
 
Sheldon,

When you enter the name precede by the current Sheet name, such as

Sheet1!myName

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You can do it manual also
See Bob his answer

I am to lazy to do it manual on each sheet<g>
 
Back
Top