Macro to delete table row, not entire row

[smiley3141]

Hi there.

I am using Excel 2007 and I have a table called "Data_Table." It is in columns E through AA. The Column Heading in AA is "Validity." I would like help with a macro that can delete all table rows where the Validity is "Outdated". There is hidden data to the left of the table so I cannot delete the entire rows.

Thank you for your help.

 

[Firefly2012]

If you can sort the data first this is a very good idea as it will ensure the SpecialCells method won't fail if your table expands to a much larger number of records (range objects are restricted I believe to 8192 non-contiguous cell addresses - sorting removes this potential problem).