ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Insert a new Worksheet AFTER the existing (Active) sheet (https://www.excelbanter.com/excel-worksheet-functions/253128-insert-new-worksheet-after-existing-active-sheet.html)

Ronnie

Insert a new Worksheet AFTER the existing (Active) sheet
 
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?

ryguy7272

Insert a new Worksheet AFTER the existing (Active) sheet
 
This should give you a few ideas:
http://support.microsoft.com/default.aspx/kb/288402

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Ronnie" wrote:

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?



All times are GMT +1. The time now is 02:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com