Can you please have a short look on the attached code, in the first row I would like to select data range in column A and also in column E, after changing their colors.
In the current version it works but also changing color for B, C, D column data ranges.
Could you advise how to change it that only the A and E column data range should be changed?
Range("A2:A" & LastRowWithValue & "", "E2:E" & LastRowWithValue & "").Select
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 14540253
.TintAndShade = 0
.PatternTintAndShade = 0