Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting and arranging sheets
I have a daily inventory report in excel that is updated every day,
and a new worksheet is added for that day. What I would like to do, is code a macro that will insert this new sheet, name it, and move it so it is the last sheet in the workbook. So far I am able to insert the sheet and name as I would like to, but I can't figure out how to tell the macro where to put it in the list of worksheets. Any suggestions or code would be greatly appreciated! Thanks! Andrea |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting and arranging sheets
Andrea,
Try something like the following With Worksheets .Add(after:=.Item(.Count)).Name = "New Name" End With -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Andrea" wrote in message om... I have a daily inventory report in excel that is updated every day, and a new worksheet is added for that day. What I would like to do, is code a macro that will insert this new sheet, name it, and move it so it is the last sheet in the workbook. So far I am able to insert the sheet and name as I would like to, but I can't figure out how to tell the macro where to put it in the list of worksheets. Any suggestions or code would be greatly appreciated! Thanks! Andrea |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
arranging sheets alphabatically | Excel Worksheet Functions | |||
Auto arranging moved sheets | Excel Discussion (Misc queries) | |||
inserting deleting rows?how do i get the other sheets to do the sa | Excel Discussion (Misc queries) | |||
linking sheets and inserting lines | Excel Discussion (Misc queries) | |||
Inserting Sheets from multiple files | Excel Discussion (Misc queries) |