Adding tab via Macro

  • Thread starter Dushyant Rajput
  • Start date
D

Dushyant Rajput

Greetings,

I have to prepare a report each week in which after compilation of all the
data I have to add one tab in each excel spreadsheet.
I have 15 sheets and all the sheets have different numbers of tab. I am
unable to conclude how to make macro to add a tab at the last of each
workbook.

Any help would be highly appreciated

Thanks
Dushyant
 
B

Bob Phillips

worksheets.Add after:=worksheets(worksheets.Count)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top