Inserting and Naming Sheets

[jcranst]

This is probably very simple but I am not sure how to do it. Here is the code I recorded to insert a new sheet in a workbook.

Sheets.Add After:=Sheets(Sheets.Count)
Sheets("Sheet34").Select
Sheets("Sheet34").Name = "Billed Summary"

My problem is the name "sheet34" is not always "sheet34" so the next line does not reference the right name. Can you give the sheet a name when you insert it?

[krjoshi]

Hi jcranst.

Can you please explain little bit more, what you are going to accomplish finally.

[Steve_Courts]

Hi,

First time for me answering a question!

Declare the sheet and a name first, then add that sheet. I'd also set up some code to check if the sheet name exists, see what I've done below (adds a sheet before Sheet2, but you might get your sheet name or the before sheet from somewhere else in your workbook or code).

Cheers
Steve

Please Login or Register  to view this content.