Hello and thank you for you help.

Basically I would like a macro that works through column A and deletes the row if a value is between 90000000 and 99999999.

an example of the data I am using

aa123456
ab123456
ac456879
zz123456
90000000
95134756

I would like the macro to delete the 90000000 and 95134756
so the data would be like

aa123456
ab123456
ac456879
zz123456

There can be up to 10,000 rows of data if this make a difference

Thank you in advance for you help