How to discovery the color...
How can I know what is the color of the value of variable?
Example:
Cell A1 = test (its in red)
VBA:
Dim var as string
Var = range(A1).value
If var.Interior.ColorIndex = red then
Msgbox red
End if
Tks,
Lisandro
|