how can i find sheet1 when it was renamed?

Hi Nono,

If only the sheet name (and not the code name) has been changed, then try
the following simple macro:

Sub TesterA()
MsgBox Sheet1.Name
End Sub


---
Regards,
Norman



"nono" wrote in message
...
how can i find sheet1 when it was renamed?

Maybe

Worksheets(1)

--
HTH

Bob Phillips

"nono" wrote in message
...
how can i find sheet1 when it was renamed?

Hi Bob,

Thank you.

My response conflated rename and move, which was probaly not the OP's
intention!


---
Regards,
Norman



"Bob Phillips" wrote in message
...
Maybe

Worksheets(1)

--
HTH

Bob Phillips

"nono" wrote in message
...
how can i find sheet1 when it was renamed?