VBA Adding and Deleting Sheets according to a list

**miconmicon** · 10-20-2013, 10:55 AM

The question is the following:

A worksheet named AllCars list all the car brands available in a dealer in the column A (starts from cell A2).
(1) For each car in the list, it checks whether there is a worksheet with the name of that car in the workbook, and if there isn’t one, it adds one; and (2) it deletes any car worksheet if the worksheet’s name is not in the current AllCars list. (Warning: The sub should also work if the AllCars list contains exactly one car brand or no car brands at all).

for example:

Cell A2: Toyota
A3: Ferrari
A4: Audi
A5: Mercedes
A6: Acura
A7: Lexus

And what I have right now is:

Please Login or Register  to view this content.

but it is nowhere near working. It adds many cells at the end, but without the car names

Many thanks in advance for your help. Any help would be very appreciated!

**miconmicon** · 10-20-2013, 11:23 AM

Okay I have done it thanks!!!

**HaHoBe** · 10-20-2013, 11:33 AM

Hi, miconmicon,

fine if you have figured it out by yourself - you should post the solution for others users who might have the same problem and mark the thread Solved via Thread Tools over the first post.

Ciao,
Holger

**bmtomahawk3** · 12-01-2013, 04:38 AM

I'm having the exact same problem.. i managed to add Sheets that are currently on my list, but i cannot delete the sheets that are no longer on my list.
this is the code i have so far to add new sheets.

I have a list of cities like
Denver
Colorado
San Diego
etc..

Please Login or Register  to view this content.

Thanks!

**HaHoBe** · 12-01-2013, 05:15 AM

Hi, bmtomahawk3,

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

You have to add code-tags when showing your procedure here on Excel-Forum according to Forum Rule #3.

The data begins on Range A2, you would need to change this to suit your needs:

Please Login or Register  to view this content.

Ciao,
Holger

**bmtomahawk3** · 12-01-2013, 07:58 AM

Thanks for your post Holgar! it works.. and i have read the rules and thanks for pointing it out.. will follow it in future

By the way, what does "If not Evaluate" and "ISREF" mean?
sorry hope you can bear with me.. newbie here

**HaHoBe** · 12-01-2013, 08:13 AM

Hi, bmtomahawk3,

Evaluate is used for working with WorksheetFunctions in VBA. ISREF is trying to build a connection to the Sheet given before the exclamation mark and Range A1 on that very sheet - if not available the sheet is not included in the workbook and should be added.

Ciao,
Holger

VBA Adding and Deleting Sheets according to a list

LinkBack

Thread Tools

Rate This Thread

Display

VBA Adding and Deleting Sheets according to a list

Re: VBA Adding and Deleting Sheets according to a list

Re: VBA Adding and Deleting Sheets according to a list

Re: VBA Adding and Deleting Sheets according to a list

Re: VBA Adding and Deleting Sheets according to a list

Re: VBA Adding and Deleting Sheets according to a list

Re: VBA Adding and Deleting Sheets according to a list

Thread Information

Users Browsing this Thread

Similar Threads

Adding and deleting to a list from two different workbooks.

Adding and deleting to a list from two different workbooks. I NEED HELP!!!!!!

Replicated adding/deleting rows on seperate sheets

Replicate adding/deleting rows on different sheets

[SOLVED] Adding And Deleting Sheets

Bookmarks

Bookmarks

Posting Permissions