Hi

I was hoping someone could help me out here please, basically I have rows and rows of data in Excel, in column H some cells start with __INVALID - so would it be possible to run a macro which would delete the whole row? So basically search and delete all rows where column c = __INVALID.

Thanks