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)
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)
change that + to a &
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
That did it. Thank you!