PDA

View Full Version : [SOLVED] Trying to set color to a range



mongoose
07-19-2019, 08:51 AM
Getting an error on this line of code...is it syntax related?


'Set cell background color to Red for a range of cells for Jan-Current Month
Range("E1:P" + .Cells(.Rows.Count, 1).End(xlUp).Row).Interior.Color = RGB(255, 0, 0)

p45cal
07-19-2019, 10:09 AM
change that + to a &

mongoose
07-19-2019, 10:54 AM
That did it. Thank you!