Insert a new Worksheet AFTER the existing (Active) sheet

R

Ronnie

I want to insert (or add) a new Worksheet to my existing Workbook, but I want
it to appear AFTER my existing (Active) Worksheet. The default places it
BEFORE my current sheet. This places Sheet2 before Sheet 1. I'd like the
new sheet (Sheet2) to be added AFTER Sheet1. Is this possible?
 

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

insert blank row and formulas 1
Copying info from worksheet to worksheet if info matches 2
Excel VBA to move cells to sheet2 based on selection in sheet1 0
match first and last name and insert column into existing sheet 1
Need Macro to Collect Multiple Worksheet Names 3
How do I insert template in new sheet of pre-existing excel file? 5
insert sheet tab is not functioning and can't add new sheet 4
How do I add NOT insert additional worksheet to existing workbook. 6

Top