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
|