I have the following code that I'm using to try and count colour fill of cells in a specified range on another worksheet, and I can't get it to quite work how I want.
The code that I can get working how I want is this:
twowk = Sheets("PROD").Range("2:2").Find(What:="2WK GATE DATE"...