How?? >> If Currency amount is less than $500,000 in column I, delete the whole row

Hello all,

I would like a formula to do the following...

Please Login or Register  to view this content.

Yes, there is a header row with text in it, which I want to remain. I'm using Excel 2003.


P.S. I hope I did the code tags right. I don't think that this is really code persay, but want to make sure I'm complying if it is. If this doesn't qualify as "code", please let me know and I won't code tag things like this in the future.

Thanks much

This is macro that will do the job. test it on a copy of your data first.

Please Login or Register  to view this content.

Insert that into a standard module and run it.

It worked like a charm!

Thanks