I have a worbook with 2 sheets named AA and BB.
I have to add several sheets sometimes 3 ,6 or 7 OR 12 sheets with their sheets names e.g AC , DE, FG, VF, DE, MC, VV etc after sheets BB
but sometimes there may be 4 or 5 or 6 or 7 named sheet after sheet BB but need to add additional sheets names after the last existing sheet
looking for vba code to do this .
Can anyone assist
Bookmarks