| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you use worksheet names in macros
I'm just learning to utilise macros and VB in excel and I am having trouble
with the following: Sheet 1 is called "WE 01-01-01" I wish to automate the process of inserting a new worksheet and renaming it "WE 08-01-01" and so on each week. Using a simple macro the insertion process is easy but the renaming part I'm having trouble with. Can anyone help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
| MAKE A LIST OF NAMES FROM REPEATED NAMES IN THE SAME WORKSHEET | Excel Discussion (Misc queries) | |||
| Macros search for names | Excel Discussion (Misc queries) | |||
| Changing VB Component Names to match Worksheet names using VBE | Excel Programming | |||
| return all worksheet tab names and chart sheet tab names in report - an example | Excel Programming | |||
Threaded Mode
