View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vinit[_2_] Vinit[_2_] is offline
external usenet poster
 
Posts: 18
Default Worksheet Name in Sequence

Hi friends,

Again an interesting topic!
I have three default sheets in workbook "Sheet1", "Sheet2", and
"Sheet3". I insert one sheet and renamed it to "MySheet". Now If I
insert any sheet then by default I want its name as "Sheet4" not
"Sheet5". If its possible then we can even extend it for "Delete"
instead of "Rename". Is there any standard way to do this other than
looping through "Worksheets" collection and then string comparison?

With Best Wishes & Regards,
Vinit