Forum Discussion
vba to detect if there is a colored cell in a range
How do I write the code for the following scenario? If range("A2:A1001") has at least one colored cell Then do > clear the color for that range ( this line I think I can do the code) End If ...
in relation to this topic,
How do I count in vba the number of colored cell (just one particular color - say red) in a range say A2:A1001?
many thanks