Getting an error on this line of code...is it syntax related?
Code:'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)
Printable View
Getting an error on this line of code...is it syntax related?
Code:'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)
change that + to a &
That did it. Thank you!