Delete Rows Marked with "X"

[amerifax]

I'm trying to delete rows that have an "X" in one column. I tried setting a filter and than using F5-Special-Visible Cells Only. The problem is if I try to many at one time Excel chocks. There's also the potential problem of not doing the F5-Special-Visible Cells Only right, over and over again, and trashing records.

I was hoping that there is a formula I could run since formulas such as:
=COUNTIF($AG$2:$AG$100916,$AG2)
can run through 1,004,500 records with no chock.

Thanks for taking the time to read.
Bob

 

[amerifax]

This is Heather...I work with Bob. I will read through your code and suggestions and sort everything out and let you know how everything works or if it worked or didn't for whatever reason.

Thanks for all your help and patience, I will let you know later this afternoon.

Heather (for Bob)