PDA

View Full Version : Excel 97



07-06-1999, 07:55 AM
How can I define a line in an Excel macro to replace the line :-
Sheets('Sheet1').Name = 'Summary'
to allow me to rename the current worksheet regardless of its name (Sheet1 in this case).
I cannot use the Sheet1 specification as when the macro is run more than once in the current session of the open file the Sheet number is incremented