My followup question is:
I would like to manually select a range of cells and then click the macro to search the values of each Selected cell, then replace values below -100 or above 300 with "" or no value.
Thanks!
-Troy
My followup question is:
I would like to manually select a range of cells and then click the macro to search the values of each Selected cell, then replace values below -100 or above 300 with "" or no value.
Thanks!
-Troy
The following should do the trick
Please Login or Register to view this content.
Last edited by mikeTRON; 03-02-2015 at 04:00 PM.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Works perfectly MikeTRON! This will be quite helpful in the future as well.
Thanks! I like your coding.
-Troy
Great, I made sure to comment everything for you so it is easy for you to audit and/or change in the future.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks