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