Define Names

[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.

 

[Ron de Bruin]

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

 

[Bob Phillips]

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)

 

[Ron de Bruin]

You can do it manual also
See Bob his answer

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

 

[Bob Phillips]

That's why you have a computer<vbg>

Bob

You can do it manual also
See Bob his answer

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