L
LUKEMUDGE
I have the VB script to change the background color of my cells working but I
would like it to change another cell in a different worksheet. Can anybody
help me out with how to program the reference?
Here is the VB script I'm using to change the colors at the moment
Range("C5").Interior.ColorIndex = -4138 - Range("C5").Interior.ColorIndex
would like it to change another cell in a different worksheet. Can anybody
help me out with how to program the reference?
Here is the VB script I'm using to change the colors at the moment
Range("C5").Interior.ColorIndex = -4138 - Range("C5").Interior.ColorIndex