Hello there,
I have tried a few different options for this and have not been able to find what I need. What I am looking for is a macro to check a range for a value and, if found, clear cell contents. One of the examples I have tried is below:
I have tried various other similar codes, but with no success.
Please Login or Register to view this content.
orPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by shg; 06-08-2015 at 07:27 PM.
Entia non sunt multiplicanda sine necessitate
There are a number of things wrong. The code does not define a range to look at so it doesn't know which cells to look in to delete the 1/0/1900. The "SheetName" should be that actual name of the sheet, default is Sheet1, Sheet2 and so on. Try this...
This will select all the cells in range A1:G8 then run through and delete any cell that contains 1/0/1900Please Login or Register to view this content.
Edit* Use SHG's code, it's much cleaner and will serve your purpose better than mine will.
Last edited by gmr4evr1; 06-08-2015 at 07:27 PM. Reason: added Edit
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Perfect! Thank you.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks