how can i find sheet1 when it was renamed?
N Norman Jones Jul 30, 2005 #2 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
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
N Norman Jones Jul 30, 2005 #4 Hi Bob, Thank you. My response conflated rename and move, which was probaly not the OP's intention!
