VB Code to add Sheets

**rizmomin** · 02-28-2019, 07:11 PM

Hello:

Please refer to attached file.
I am trying add sheets by adding below code but its giving error.
Pls help correct code

Please Login or Register  to view this content.

Let me know if you have any questions.
Thanks.

**TMS** · 02-28-2019, 07:27 PM

If you add a sheet, it WILL BE the Active Sheet ... and it will be empty. So, trying to name a sheet based on a (empty) cell on that Active Sheet will error out. You will need to explicitly refer to the sheet where the cell with the sheet name exists.

**rizmomin** · 02-28-2019, 07:34 PM

Hello TMS:

Thanks a lot
i got it.

Riz

**TMS** · 02-28-2019, 07:59 PM

You're welcome. Thanks for the rep.

VB Code to add Sheets

LinkBack

Thread Tools

Rate This Thread

Display

VB Code to add Sheets

Re: VB Code to add Sheets

Re: VB Code to add Sheets

Re: VB Code to add Sheets

Thread Information

Users Browsing this Thread

Similar Threads

VBA code to sort data from multiple sheets into sheets depending on the value of a column

[SOLVED] Want to apply code to all sheets available in workbook except two sheets with fast working

[SOLVED] VBA code adds sheets from other files to a master WB, but the sheets are in reverse order

Programming code : Sheets.Add After:=Sheets(Sheets.Count)

[SOLVED] How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook?

[SOLVED] How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook?

How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook?

Bookmarks

Bookmarks

Posting Permissions