Highlight Row with a specific range

[adtc]

Hi team,

Have been working on a HUGE project and, thanks to all the help from this forum, it's nearly done!
Just trying to get some of the aesthetics in order now.

I have the following line of code:

cell2.EntireRow.Interior.ColorIndex = 3

It highlights (in red) the .EntireRow of the targeted cell (cell2). But this means it goes ALL the way to the right to cell XXXXY or something to that effect.

I was hoping it could be altered to highlight only A:N on that row.

Thank you for any help/ideas, much appreciate.
And thanks again to everyone that has helped me get to this point!

ADTC.

 

[prajul89]

Range(Cells(cell2.Row, 1), Cells(cell2.Row, 14)).Interior.ColorIndex = 3

14 Represents column "N" You change it accordingly.

 

[VoG]

Try

Range("A" & cell2.Row).Resize(, 14).Interior.ColorIndex = 3

 

[Peter_SSs]

Yet another option

cell2.EntireRow.Resize(, 14).Interior.ColorIndex = 3

 

[adtc]

Perfect.

Thank you very much for the prompt responses prajul89 and VoG.

Project complete

 

[adtc]

** and Peter_SSs !