Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to highlight a line of cells when the cell is selected. I tried
the following code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim rng As Range Dim ycell As Range Set ycell = ActiveCell.EntireRow.Cells(3) Set rng = Range(ycell, ycell.Offset(0, 5)) rng.Interior.ColorIndex = 36 End Sub but I get an error that says 'Unable to set ColorIndex property of the interior class'. What am I doing wrong here? or is there a better way to do this? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
How to highlight cells... | Excel Discussion (Misc queries) | |||
Highlight Cells | Excel Programming | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
Highlight all cells, except top row? | Excel Programming |