Delete columns based on cell criteria

try:

Please Login or Register  to view this content.

hi, enhydra, please check attachment, run code "test"

Thanks tlafferty, it deletes the first column with FP1 but then it doesn't delete the columns with FP2 FP3 or FP4.

E.

Hmmm....have you looked at watersev's attached solution?

Yes, I was just trying it out and it seems to work.

E.

Thanks watersev.

E.

hi, enhydra, though you marked the thread as Solved and I know that the code is not right, I will post "excuse me" file and code attached that is working correctly.

you may want to Use an autofilter function filter for what you want to delete, then use the special cells function to delete all visable cells, you then loop it to address your next criteria, i.e. GoTo first and re use the code with a new criteria. This is a much faster way then going row by row and individualy deleting each row. If you want an example I'll post one for you.

Enhydra or Watersev, could you please post the code from the excel file in this forum. For some reason I cannot open the excel file at work. Later I will also try to open it from my pc at home. Thank you.

Thank you, and sorry. I will review the forum rules.