Inserting Worksheets to the RIGHT

[Guest]

Does anyone know how to insert a new worksheet to the RIGHT of the currently selected tab

Please help
Please Email responses to

(e-mail address removed)

Thanks

Gabe

 

[Guest]

Two ways:

Click (and hold) on a tab you may wish to copy. Press
(and hold) the Ctrl key. Drag the worksheet to the right.
Release both the mouse button and the Ctrl key. The sheet
will then be copied to the right.

Insert a new worksheet. It will appear to the left.
Select, drag and move it to the right.

Allan

-----Original Message-----
Does anyone know how to insert a new worksheet to the

RIGHT of the currently selected tab?

 

[Chip Pearson]

Gabe,

This is possible only with some VBA code:


With ThisWorkbook.Worksheets
.Add after:=.Item(ActiveSheet.Index)
End With



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[JE McGimpsey]

For a suggestion on how to change your menu's Insert/Worksheet behavior,
take a look here:

http://www.mcgimpsey.com/excel/insertsheettoright.html

 

[Blaster]

Why not just insert a new sheet then drag and drop it to
the right of the other sheets?

Blaster

-----Original Message-----
Does anyone know how to insert a new worksheet to the

RIGHT of the currently selected tab?