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" wrote in message
...
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.