Hello,
I have a worksheet with headers in Row 3. My sheet is structured in repeating segments. What I need to do is find any header in row 3 with the title "New" and clear that column from rows 4 to 400.
I'm sure this is possible, but I can't seem to get the coding right.
Hi phbryan,
See if this code makes sense to you.
Instead of
Please Login or Register to view this content.
I like to use sometimes.Please Login or Register to view this content.
I've shown both types in my code above.Please Login or Register to view this content.
Last edited by MarvinP; 12-06-2022 at 11:47 AM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi MarvinP,
Both versions of this code work, but only for the first occurrence of "New" in row 3. I need the code to continue and find the next occurrence of "New".
I have "New" in J3, O3, T3, etc.
Hi phbryan,
Small change to clear All those New columns looks like this:
Please Login or Register to view this content.
That worked!
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks