Hi,

I have a list which begins in row 5. In column "A" there is a date
followed by data in 9 more columns in that row.

Before Macro:

Date Comment

06-01-09 (cell A5) Expired (cell B5)
07-01-09 (cell A6) Expired (cell B6)

I want a macro or VBA code that will take a range (say A5:J500) and
clear the contents of all rows (starting in row 5) which have a column
A: date 06-30-09 (if I could use a cell reference for this date it
would be even better).

After Macro:

Date Comment

06-01-09 (cell A5) Expired (cell B5)

I don't want to record a filter and use that in a macro because a
filter hides the rows with data. This causes a problem as I have
another routine that copies into those rows when the spreadsheet is
updated and then performs a sort, I need to have all rows visible.