I need to remove all strikethrough lines from A to C columns and leave anything outside of it.
Also, if the whole row is not completely strikethroughed just the one value is, then still remove the whole row.
i have attached a sample with examples
I need to remove all strikethrough lines from A to C columns and leave anything outside of it.
Also, if the whole row is not completely strikethroughed just the one value is, then still remove the whole row.
i have attached a sample with examples
Do we include col D in the check for strikethrough?
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Hi Arkadi,
No Just from A to C leave the D. Thank you!
1. What I mean is... if D is has strikethrough, do we clear the other columns?
2. Also, is D always the last column or does that vary?
3. Do we remove the Strikethrough from column D? or just the others.
Leave column D as it is even if its strikethrough, the data should remain there.
But inside A to C anything has a strikethrough, delete the whole row. But deletion is limited inside A to C only, anything outside C column remians as it is.
Thanks
As I understand it, we are only concerned with columns A-C for checking strikethrough font then, and only clear A-C if any of those cells have strikethrough...
Give this a try:
Please Login or Register to view this content.
Legend!!! Thats perfect, how would I change the area sorry? Instead of A to C. A to D and have data in the E column?
You would change the 3 to a 4 in the 2 lines where you see:
That would check the first 4 columns for strikethrough and then clear those 4 colums if found.Please Login or Register to view this content.
Thanks for the rep and marking the thread as solved
Could you explain whats going on in the code ? If not, thats ok
Hope this helps a bit:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks