This macro deletes numbers but not text .

[I need excel help]

Hello all ,

I am hoping to get a small change made to this macro so I can delete all rows except when
col AB (RaceTrackCondition) is Dead or heavy . I can alter if able to later .

The macro del rows placings was the first I obtained and simply deletes all rows except for 1 or 1= in col
AL . Works great .

I have adapted it to work for col Q (del rows remove dist) , here it leaves the 5 distances
I want left . Works great .

But I can not get it to work with text , words in col AB . Doesn’t work at all .

Any ideas would be great . Should end up with 311 rows left plus headings .
Thanks .

[mike7952]

This will do it. Just modified your code. Your using "UCase" so Heavy and Dead in your select case needs to "HEAVY" and "DEAD"

Please Login or Register  to view this content.

[I need excel help]

Thanks Mike , i have your revised macro working well . Nice simple answer .
Thanks for you help .