Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I saw many post in this newsgroup about row highlighting, this code written by jemcgimpsey I found in this newsgroup works well: ----------- Private Sub Worksheet_SelectionChange(By Val Target As Excel.Range) Static oldRange as Range Static colorIndices(256) As Integer Dim i As Integer If Not oldRange Is Nothing Then 'Restore color indices For i=1 to 256 Cells(oldRange.row, i).Interior.ColorIndex=colorIndices(i) Next i End If For i = 1 to UBound(colorIndices) colorIndices(i)=Cells(ActiveCell.row,i).Interior.C olorIndex Next i ActiveCell.EntireRow.Interior.ColorIndex=15 Set oldRange=ActiveCell.EntireRow End Sub ---------- Now I need your help because I'd like to to have highlighted only the cell on coloumn "A" - not the entire Row. I'm sure you Excel experts can easly change this code, I'd be greatful if somebody can help me. Thanks, Ale. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
highlighting | Excel Discussion (Misc queries) | |||
highlighting | Excel Discussion (Misc queries) | |||
Highlighting a Row | Excel Worksheet Functions | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
Highlighting changes | Excel Discussion (Misc queries) |