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
Found easily on the net and edited to meet your needs:
Please Login or Register to view this content.
If the solutions provided within this Thread takes care of your question:
Please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
You can also click on * (star) Add Reputation to add reputation to those who have put their time and efforts to help you in this Thread.
This is another way to say Thank You to them.
This is not as neat as JRidges Code but it should be faster:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks