Insert Sheet

[STEVEB]

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!

[Chip Pearson]

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" <STEVEB.21uenf_1137608457.253@excelforum-nospam.com>
wrote in message
news:STEVEB.21uenf_1137608457.253@excelforum-nospam.com...
>
> 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
>

[STEVEB]

Thanks Chip,

It worked great! I appreciate your help!