delete Macro
 

I have a table of data that downloads to Excel in a very unfriendly format.
I want to delete all rows where a particular column doesn't contain a numeric
value. For example, column G will always contain a numeric (except where a
header or footer gets in the way) - I want to delete all rows where there
isn't a numeric in column G (could be a blank cell or text).

Any help will be appreciated.