Macro to delete certain items in Col B

**Howardc1001** · 01-30-2020, 08:34 AM

I have a macro the deletes rows in Col b containing

I would like to neaten the code by putting the criteria for items to be deleted in an array so one can add more items to be deleted if necessary

Please Login or Register  to view this content.

your assistance is most appreciated

**mehmetcik** · 01-30-2020, 05:25 PM

Please Login or Register  to view this content.

**Howardc1001** · 01-30-2020, 10:14 PM

Thanks for the helping in improving my code making it easier to add additional items to be deleted if necessary

**Howardc1001** · 01-31-2020, 01:52 AM

In testing the code I get an error message variable not defined

Please Login or Register  to view this content.

I then set up Dim As a variant

I then run the macro and get variable not defined and it refers to code below

Please Login or Register  to view this content.

It would be appreciated if you could kindly amend the code

**jolivanes** · 01-31-2020, 02:00 AM

What happens if you Dim Count As Long?
And I think it should be

Please Login or Register  to view this content.

**Rick Rothstein** · 01-31-2020, 02:13 AM

Here is a different macro that you can try (it is a little bit more compact and, untested, but I think it might be faster as well)...

Please Login or Register  to view this content.

Note: Add items to the red highlighted comma/space delimited list as needed

**Howardc1001** · 01-31-2020, 02:34 AM

Thanks for the help Rick

**Howardc1001** · 01-31-2020, 02:40 AM

thanks for you input jolivanes

I have set up the variables and not get a compile error :expected array

Please Login or Register  to view this content.

**Rick Rothstein** · 01-31-2020, 02:47 AM

Originally Posted by Howardc1001

Thanks for the help Rick

Did my code work for you?

**Howardc1001** · 01-31-2020, 02:51 AM

Hi Rick

thanks -Your code worked perfectly and very fast

**Rick Rothstein** · 01-31-2020, 02:57 AM

Originally Posted by Howardc1001

Your code worked perfectly...

Okay, great! (I wasn't sure if you were just thanking me for participating or if you were thanking me because my code worked.)

**Howardc1001** · 01-31-2020, 03:34 AM

I thanked you for your code that worked perfectly

Hope you have a great day Rick

Macro to delete certain items in Col B

LinkBack

Thread Tools

Rate This Thread

Display

Macro to delete certain items in Col B

Re: Macro to delete certain items in Col B

Re: Macro to delete certain items in Col B

Re: Macro to delete certain items in Col B

Re: Macro to delete certain items in Col B

Re: Macro to delete certain items in Col B

Re: Macro to delete certain items in Col B

Re: Macro to delete certain items in Col B

Re: Macro to delete certain items in Col B

Re: Macro to delete certain items in Col B

Re: Macro to delete certain items in Col B

Re: Macro to delete certain items in Col B

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to delete certain items then count remaining items #2

[SOLVED] Macro to delete certain items then count remaining items

Macro to delete items contain 1 and less

[SOLVED] Macro to delete unwanted items

[SOLVED] Macro to delete all Duplicate items in Col B

[SOLVED] Macro to Delete Rows and Renumber Items after

[SOLVED] Macro for Excel to add up items and delete extra lines?

Bookmarks

Bookmarks

Posting Permissions