G
grahammal
Cells.FormatConditions.Delete
With ActiveCell
..FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
..FormatConditions(1).Interior.ColorIndex = 20
End With
I have the above set up in my worksheet Tab to turn the active cell
light blue.
It works fine but it also seems to disable my Copy/Paste facility.
If I disable the above feature then Copy/Paste is normal.
Any ideas???
With ActiveCell
..FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
..FormatConditions(1).Interior.ColorIndex = 20
End With
I have the above set up in my worksheet Tab to turn the active cell
light blue.
It works fine but it also seems to disable my Copy/Paste facility.
If I disable the above feature then Copy/Paste is normal.
Any ideas???