Excel VBA - Delete rows when a cell contains a date

Question

I am trying to write code that does the following:

Finds Cell A4.
If cell contains a date, delete the entire row.
I want this to loop until the cell in column A does not contain a date. Once the cell is blank, the loop can end.

fwiw there are better ways speed wise to handle this than a For-loop over a range. AutoFilter, inserting a working column formula or using variant arrays are all vastly superior to looping over a range. If you are open to other methods let us know — brettdj
– brettdj, Commented Nov 18, 2012 at 0:21
Who gave this +1 ? There is not even a question in this post. It's just an affirmation that OP wants to do this (and did not try to do it or does not care to show his work). — ApplePie
– ApplePie, Commented Nov 19, 2012 at 12:14
@AlexandreP.Levasseur, there is a question. But from the looks of it he hasn't done any research whatsoever and probably has zilch for code. — CustomX
– CustomX, Commented Nov 19, 2012 at 12:18
@t.thielemans: There is no question here. First clue: look for a question mark. ;) — ApplePie
– ApplePie, Commented Nov 19, 2012 at 12:20

ApplePie · Accepted Answer · 2012-11-19 13:39:10Z

3

Here's all you need to do this:

Using the VBA function IsDate

If the value returned is true on the value in Range A4

Delete entire row of Range A4

If not then your sub is over.

Really it should not be much longer than 5-9 lines of code and it's all very very very simple. Come back if you have trouble writing the code and ask a specific question about what you are having trouble with.

edited Nov 19, 2012 at 13:39

answered Nov 19, 2012 at 12:19

ApplePie

8,9525 gold badges41 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CustomX Over a year ago

Oh I misunderstood, only cell A4 can't contain a date? I thought the entire column A! ;)

Collectives™ on Stack Overflow

Excel VBA - Delete rows when a cell contains a date

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related