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

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