Hello,

Thanks for writing back. I wish I knew coding using VBA, but what I
have is COBOL and some C. Let me tell you what I have -

The filename is e2edata.xls - The sheet in it is called dv05Output.
The first row is a header which has column names viz -
Product, Version, ErrorInd (Coumn C -1 of the criteria), Some Col, Some
Col, Some Col, Country (Coumn G - 1 of the criteria for deletion), Some
Col, Category (Column I - 1 of the criteria for deletion). The actual
values for data start after the header row, so they start in row 2. By
using the record macro button, I have created a macro that I undestand
by looking, but couldn't have done it myself.

This macro is called Auto_Open which is executed when the spread-sheet
is opened thru a batch process (.cmd or .bat). the macro does it's
thing and closes the .xls for me. Problem is the deletion - it would
not delete the said rows - so I have been doing it manually - I am
going to try your code - but I doubt it will work since commands like
Range("A1").Select may be different for me - Does this mean start from
the first cell - my ErrorInd is column C, the first valuewould be in
Cell C2 - next would be G2 and I2 -

I will try and run thru the macro you created - maybe I can figure it
out - but would appreciate if you would tell me how exactly I would
code this -

Thx.