Dear all,
I am trying to write a macro that deletes rows from a column (variing in position, but with a constant title "Contaminant") from a spreadsheet. I have tried to put something like this together but somehow it does not work completely:
-First seach the column header "Contaminant"
-Select entire column and set it a s target column for the deleting operation
- with "for" the used range (I have set it to 20000, do not know how to specify used cells) "if" cell in "contaminant " column has value "+" then delete row.
Does anybody know what is wrong with this code, or suggest a better way?
Please Login or Register to view this content.
Bookmarks