Reffering to sheets - not by name

Hi, this is probably a really easy one.

I have this code:

Sub Button17_Click()
Sheets("Blank 1").Activate
Range("E6").Select
End Sub

...to assign to a button to change sheets (obviously...). The trouble is that the sheets in the workbook change name, via another macro. So the sheet known as 'Blank 1', when filled in, might be called something else entirely.

Can I refer to the sheet by some other means to keep this macro working?

Sheet1.Activate

...figured it out myself :-)

Hi

You can refer to it by CodeName - this is another property of a worksheet and isn't so easy to change so it is much more stable. If you look in the Project Window of your VBE (top left usually) at your workbooks, the codenames will be the name given first for each sheet. The name is what is in the brackets.

So, you can refer to the sheet like:

Sheet1.Activate   'amend codename as appropriate