You don't need VBA. Just do a filter (DataFilterAutofilter) and select a
custom value of Blank and not Cred, and then just delete the visible rows.

--
HTH

Bob Phillips

"William Horton" <William wrote in message
...
I am downloading to Excel a report from a financial system. The reports
length (# of rows) will vary. I want to delete the entire rows in a range
called Company_Code (a range for rows in column "A" up to the last row
that
has data) that are either "Blank" or do NOT contain the values "Cred",
"PTUB", "CMEX". Can somebody please provide me with the VBA code to do
this?

I've played around with this forever and can't get it to work. Also, I
don't know if I am doing it the most efficient way.

Any help would be MUCH appreciated.