Thread: Can you use worksheet names in macros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lyn Lyn is offline
external usenet poster
  
Posts: 35
Default 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
Reply With QuoteReply With Quote