How could the following code made to highlight the selected cell instead of C67 only?
Code: Select all
Sub Highlight()
Range("C67").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = vbYellow
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End Sub