create named worksheet based on existing numeration
Hi SteveDB1,
There are a number of topics on this website if you do a search for
"count specific sheets"
However if ALL your sheets are numbered 1,2 ,3 4, etc then your next
sheet will be Sheet.Count + 1 if you do the count before creating the
new sheet, or simply Sheet.Count if after.
If you have other types of sheet names you might want to set up a
'counter & loop thru all the sheets testing to see if the name =
integer (you will have to convert the name to an integer as sheet
names are strings)
Hope this helps. Repost if you get suck
Regards
Michael.
|