refer to the sheets Name property in my code (not what is on the Tab)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I changed the Name property of a worksheet in the Properties pane of the VBA Editor. This does not change the text that shows up on the sheets "Tab."

I want to refer to the sheets Name property in my code (not what is on the Tab) incase the your changes the name on the Tab

How do I do this? (I know I've seen this posted here before, but I can't find it.
 
Sandy,

Something like

Sheet1.Range("A1")

as against

Worksheets("Sheet1").Range("A1")

for the tab name

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Sandy said:
I changed the Name property of a worksheet in the Properties pane of the
Click to expand...
VBA Editor. This does not change the text that shows up on the sheets "Tab."
I want to refer to the sheets Name property in my code (not what is on the
Click to expand...
Tab) incase the your changes the name on the Tab.
How do I do this? (I know I've seen this posted here before, but I can't
Click to expand...
find it.
 
Hey Sandy,

if your sheetname is "InnerSheetName" but on the tab it
says "Sheet1"

you can use [InnerSheetName] to refer to the object.

try this:
msgbox [InnerSheetName].name

this will give a message box with the tab name.

this should work for you.

Regards
Sanjay VA
-----Original Message-----
I changed the Name property of a worksheet in the
Click to expand...
Properties pane of the VBA Editor. This does not change
the text that shows up on the sheets "Tab."
I want to refer to the sheets Name property in my code
Click to expand...
(not what is on the Tab) incase the your changes the name
on the Tab.
 
so will this

msgbox InnerSheetName.name


without the brackets.

--
Regards,
Tom Ogilvy

sanjay va said:
Hey Sandy,

if your sheetname is "InnerSheetName" but on the tab it
says "Sheet1"

you can use [InnerSheetName] to refer to the object.

try this:
msgbox [InnerSheetName].name

this will give a message box with the tab name.

this should work for you.

Regards
Sanjay VA
-----Original Message-----
I changed the Name property of a worksheet in the
Click to expand...
Properties pane of the VBA Editor. This does not change
the text that shows up on the sheets "Tab."
I want to refer to the sheets Name property in my code
Click to expand...
(not what is on the Tab) incase the your changes the name
on the Tab.
How do I do this? (I know I've seen this posted here before, but I can't find it.
.
Click to expand...
Click to expand...
 
Back
Top