Positioning Inserted worksheets?

garymu16

Board Regular
Joined
Sep 15, 2006
Messages
139
How do I get excel to automatically put any inserted worksheets to the end instead of the start of the tabs?
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

As far as I know you don't, but you can use a macro for a shortcut:

<font face=Tahoma><SPAN style="color:#00007F">Sub</SPAN> AddSheets()
    Sheets.Add After:=Sheets(Sheets.Count)
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

Hope that helps,

Smitty
 

Watch MrExcel Video

Forum statistics

Threads
1,113,956
Messages
5,545,177
Members
410,668
Latest member
Gaexel
Top