Accessing name property of ActiveWorksheet

[SiddersAtHome]

Hi All

Possibly a very simple question. In VB when I select a worksheet, I can amend the (Name) of the worksheet in the properties window. There is also the .Name property which is the same as the sheet tag name.

I can use the (Name) in vb code to identify the sheet e.g.

ControlSheet.cells(1,1)

without having to define ControlSheet as a worksheet first.

How do I access the (Name) which appears at the top of the list of properties in the properties window.

Many thanks

Sidders

 

[RoryA]

It's

Activesheet.codename