Steve,
Try
With ThisWorkbook.Worksheets
.Add(after:=.Item(.Count)).Name = "New Name"
End With
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"STEVEB"
wrote in message
...
Hi,
Is there a way to insert/add a sheet at the end of a workbook,
without
knowing the # of sheets or the name of the sheets(The name &
number of
sheets changes weekly)?
Any help would be greatly appreciated!
--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile:
http://www.excelforum.com/member.php...fo&userid=1872
View this thread:
http://www.excelforum.com/showthread...hreadid=502573