Inserting and arranging sheets

  • Thread starter Thread starter Andrea
  • Start date Start date
A

Andrea

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
 
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 (e-mail address removed)
 
Back
Top