Looping through and deleting rows if cells contain a value

[martinez77]

hey all,

I have a normally easy task that is causing me some grief. In column f of my data I either have a number or this "____________". My goal is to delete the entire row if that line is present but my code is not finding that value in my range
I am wondering is this some format value or something, but it shows up in the formula line as a line. Doesn't appear to be an underline, but I could be wrong. Below is my code.
Thanks in advance

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Can you attach a sample file with some data?

[martinez77]

Sure thing. See below.

coursetest2.xlsx

[jolivanes]

What do you get when you run this?. Underscore is Char95.
Change the A12 reference to the cell with the characters to be deleted.

Please Login or Register  to view this content.

[jolivanes]

They are underscores (Char95)
So you'll have to delete Char95's

[jolivanes]

Not very fast but it should delete all the underscores (if there are 12 in a cell).
Instead of the "Delete Shift:=xlUp" you can of course also use "ClearContents"
Try it on a copy of your workbook first though.
Good luck.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[david000]

Try looking for the string length instead. It looks like your using a fixed string length of 12 characters.

Please Login or Register  to view this content.

[david000]

Try looking for the string length instead. It looks like your using a fixed string length of 12 characters.

Please Login or Register  to view this content.

[martinez77]

Thank you all. That helped me get over the hump. Got it working now.