| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 1678 | 1999-06-06 20:55:00 | Excel 97 | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 2030 | 1999-06-06 20:55:00 | 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 |
Guest (0) | ||
| 1 | |||||