What VBA code would check column M and clear contents in cells with values greater or equal to 30,000 as that is what I need to set up?
What VBA code would check column M and clear contents in cells with values greater or equal to 30,000 as that is what I need to set up?
May be something like that
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
If you only want to clear cells in Column M (and not entire rows) for that criteria, it might be easier without VBA. Filtering out values less than 30K and delete what remains.
Of course this autofilter can be done using VBA also, this way avoiding loops.
.. and don't forget to have fun!
Bogdan.
mark SOLVED and Add Reputation if my answer pleases you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks