Hello -
I have a very large sheet so I'm looking for a way to look at every cell with data on the sheet and if the cell DOES NOT contain the @ symbol to clear contents of that cell.
I've used the below for small data sets but this sheet can very a lot in regards to row and column count and setting a defined range isn't working.
If i expand the range to A1:ZZ300000 the program crashes obviously.
Please Login or Register to view this content.
any help is appreciated.
How aboutPlease Login or Register to view this content.
Last edited by Fluff13; 12-11-2020 at 04:06 PM.
[removing] Misread the request.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
wow that worked great and much more efficient that what I was trying!!! big thanks!
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks