Insert Sheet
 

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

Insert Sheet
 

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

Insert Sheet
 

Thanks Chip,

It worked great! I appreciate your help!


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=502573