Alternate way to refer to sheets???
Hi Robert
Each sheet will have a number assigned to it. Sheet1 will be 1
sheet2, is 2 no matter what you call sheet2.
Worksheets(2).Activate
The above will activate the sheet no matter what the name of "Sheet2"
becomes.
Take care
Marcus
|