Thread: Copy sheets.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Tom is offline
external usenet poster
 
Posts: 25
Default Copy sheets.

Hello,

how can I copy sheets in same workbook and set immedietly new name for this
"copy" by one instruction.
When I used Sheets("test").Copy excel automaticly generate "test (2)" or
"test (3)", this I dont need.

thanks Tom