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?