Delete rows

[lashellr]

Hi,

I am a VBA novice in search of solution that is probably very simple. I have a Column H which has a bunch of dates. I am trying to create a VBA that will delete all rows with dates in Column H that are great than 45 days from today. If this issue is better suited for a formula of some sort, please advise.


Bonus:
Is there a macro that will insert a blank row between data subset and fill it yellow? For example: I have 100 records (row A1:A100 in the eastern market. Immediately below that is the data for the western market, which is an additional 250 record (row A101:A351). I want to leave everything as it is and simply insert a blank row to divide eastern from western. then shade it yellow . If this is too much, please this regard as it is not as important. I just thought it'd make my report cleaner.

[alansidman]

Try this bit of code:

Please Login or Register  to view this content.

[lashellr]

I received a debug error for If Date - Range("H" & i) > 45 Then Can't execute code in break mode

[alansidman]

Post your sample spreadsheet as I ran this code with a list of dates in column H and it worked without incident.

What is the error message you get? Are the values in column H dates or text?

[lashellr]

The message was Can't execute code in break mode. There was an arrow pointing to this line code...... If Date - Range("H" & i) > 45 Then

Here's a sample of Column H

expire_dt
09/15/14
09/15/14
09/15/14

[alansidman]

Looking at your data in the post does not help me to help you. That is why I asked to see your spreadsheet or at least a small sample of it with the applicable fields.

What happens if you run the code not in break mode? Does it work? You did not respond to my question about the dates. Are they truly formatted as numerical dates or text? If they are text, then this code will probably fail.

[lashellr]

Please find the requested information attached. I also added a second tab with screen shots of one of the errors. The dates are note formatted as text.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[lashellr]

Worked like a charm. Thank you both so much!!

[JOHN H. DAVIS]

For the second part:

Please Login or Register  to view this content.