Home |
Search |
Today's Posts |
#1
|
|||
|
|||
insert worksheet
How do you insert a worksheet after the last worksheet?
|
#2
|
|||
|
|||
I just insert the sheet normally, by right-click Insert Sheet and this
puts it one sheet to the left of my last sheet so then I just left-click on it and drag it over into the proper place at the right end..........if you are copying an entire sheet, then there is an option in the process allowing you to select where to put it...... Vaya con Dios, Chuck, CABGx3 "Katie" wrote in message ... How do you insert a worksheet after the last worksheet? |
#3
|
|||
|
|||
Hi Katie,
If instead of inserting and dragging the tab, you want a macro solution to simply add a sheet at the end of the other sheet tabs you could use the following: Sub add_sheet_at_end() Sheets.Add After:=Sheets(Sheets.Count) End Sub Additional snippets of code in http://www.mvps.org/dmcritchie/excel/sheets.htm If not familiar with macros see http://www.mvps.org/dmcritchie/excel/getstarted.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "CLR" wrote in message ... I just insert the sheet normally, by right-click Insert Sheet and this puts it one sheet to the left of my last sheet so then I just left-click on it and drag it over into the proper place at the right end..........if you are copying an entire sheet, then there is an option in the process allowing you to select where to put it...... Vaya con Dios, Chuck, CABGx3 "Katie" wrote in message ... How do you insert a worksheet after the last worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i insert the name of the worksheet into a field? | Excel Discussion (Misc queries) | |||
insert picture in header section of excel worksheet | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
Insert worksheet | Excel Worksheet Functions | |||
insert worksheet gives me 3 duplicate sheets not one | Excel Discussion (Misc queries) |