Adding tab via Macro

  • Thread starter Thread starter Dushyant Rajput
  • Start date 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
 
worksheets.Add after:=worksheets(worksheets.Count)


--
HTH

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to copy portion of each sheet and paste into the first sheet asa picture 1
Excel Monthly Spread sheet. 12
Command Button 3
Duplex printing 7
How do I move entire row from one excel sheet to another 3
Macro to Compile Data from Different Sheets 2
Data Entry & tabbed spreadsheet question 3
How do I stop pasted cells updating when the source cells are chan 1

Back
Top