VBA - Delete rows with certain data

**ChrisFoster1uk** · 09-04-2019, 07:59 AM

Hi All,

My VBA knowledge is quite limited so please forgive any stupid questions.

I have some code that deletes any rows where the current year is in column B. This is as below.

Please Login or Register  to view this content.

This works fine where there is cell with the current year in column B, but it doesn't work where the current year isn't present.

Please could someone advise how I can skip this and go to the next step of my coding in the event the current year is not in any cell within column B?

Kind Regards,

Chris

**Pepe Le Mokko** · 09-04-2019, 08:20 AM

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

As yiu are new I will add the link https://www.mrexcel.com/forum/excel-...tain-data.html

**yoursamrit2000** · 09-04-2019, 08:21 AM

EDIT: Moderator has already checked duplicate forum posts, please avoid that to comply.

A little more info about what you are trying to achieve.

But this should get you working

Please Login or Register  to view this content.

**ChrisFoster1uk** · 09-04-2019, 09:27 AM

Originally Posted by Pepe Le Mokko

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

I'm really sorry, this is totally my fault. I wasnt aware of the affiliation between the two forums. Sorry again.

**Pepe Le Mokko** · 09-04-2019, 10:44 AM

If you have read https://www.excelguru.ca/content.php?184 as suggested, you would have understood that there is no connection between our board and MrE.
I suggest you take a moment to read our forum rules. (not so many and rather clear)
Thx

**ChrisFoster1uk** · 09-04-2019, 10:47 AM

Yep, like I have already said, it was totally my fault. Wont happen again.

**Pepe Le Mokko** · 09-04-2019, 10:58 AM

Thanks a lot

VBA - Delete rows with certain data

LinkBack

Thread Tools

Rate This Thread

Display

VBA - Delete rows with certain data

Re: VBA - Delete rows with certain data

Re: VBA - Delete rows with certain data

Re: VBA - Delete rows with certain data

Re: VBA - Delete rows with certain data

Re: VBA - Delete rows with certain data

Re: VBA - Delete rows with certain data

Thread Information

Users Browsing this Thread

Similar Threads

VBA to delete rows starting from row 18 and delete data in one column from row 17

[SOLVED] Move data on duplicate rows (different columns) to one row and delete extra rows?

VBA to find specific data, select the rows that contain this data & delete all other rows

how to data transfer everyday into same sheet new bottam rows without delete rows data

[SOLVED] Delete blank rows between data rows, shift rows up, then repeat

[SOLVED] VBA insert/delete rows to accommodate exact number of rows from incoming data

Delete duplicate rows with same data in certain columns for million rows

Bookmarks

Bookmarks

Posting Permissions