I have tried to write code that where Grand Total appears in Col A, then to fill Color the Cols A:C in the samerow as where Grand total appears
I get an error and the following code is highlighted
Range("A" & r & ":C").Interior.Color = 65535
it would be appreciated if someone could assist...