I am trying to adapt a loop I used in a different sub to look through my sheet and find the rows where a conditional formatting rule I made has highlighted the cells yellow and send an email out. However, I am getting an application-defined or object-defined error when I try to run it. Any suggestions on how to fix this? Thank you in advance!
I get the bug on the line "Do While Len(start_cell.Cells(i, 1).Value) > 0"
Please Login or Register to view this content.
Thank you again for any help !
The variable i is not initialized, so it's zero, which is invalid when you're starting in row 1.
Entia non sunt multiplicanda sine necessitate
I have changed start_cell to B3 (where my data starts) but I am still getting the error. I think its because of the "If Range("B:U").FormatConditions(1).Formula1 Then" line. I am trying to find the rows that meet my conditional formatting rule, but I'm not sure how to call upon the rule. Is it possible to name conditional formatting rules?
You're now getting an error on a different line of code, no?I have changed start_cell to B3 (where my data starts) but I am still getting the error.
I'm sorry. Yes, now I am getting a type mismatch error on the line: "If Range("B:U").FormatConditions(1).Formula1 Then"
It's very messy trying to figure out what conditional formatting is doing for the general case. I suggest you duplicate whatever logic is used in conditional formatting in code.
I am working on that now. Thanks for the advise! I will post back once (if) I get it working.
This code works! Thanks for your advise.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks