I'm trying to highlight a row that's assigned to "RowNum" I want to highlight Columns A through O. I've tried the things below, But receive syntax errors on each.
sh1.Cells(RowNum, 15).Interior.Color = RGB(127, 187, 199)
sh1.Range("A" & RowNum : "O" & RowNum).interior.color = rgb (127,187,199)
In the past, I've used this to highlight a set range or individual cells.
sh1.Range("W1:X1").Interior.Color = RGB(252, 213, 180)
I know I've done this in the past, either that or I am suffering a concussion.