Delete all cells that are not dates

[jeck876]

Looking to take two columns and delete Column A and B if Column A is not a date.

For example in workbook 3
A8:B8 should be deleted
A12:B12 should be deleted


If Column A is not a Date, A and B should be deleted for that row

[JOHN H. DAVIS]

There is no data in Column A on your sample.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[jeck876]

could you include a similar macro that would only delete Column A if does not start with a date??

And Thank you this was a perfect solution to what i asked for.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Try:

Please Login or Register  to view this content.