I am attempting to delete entire rows if a certain column is false. This column has the following function:
=IF(MID(A1,35,3)="CMD",1,"")
So, if the cell (in column R) is "", I guess, I need the row deleted, and if it is 1, then I want to keep it. I am very lame with VBA and cannot find a command to delete an entire row, and the only example codes I'm finding are to delete blank rows. I have about 12 spread sheets, and each has about 65,000 entries (I would have liked it in 2 but it wouldn't fit, maybe once I delete everything I don't need), so I don't expect it to be fast, but I need some help. Would it be easier if I made the false something other than ""?

Thanks for the help
Catherine