Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I am reading a book on Excel and VBA programming (for Excel 2000). There is one example in the book that I could not get to work. See the code below. This code is Workbook SelectionChange event, which is supposed to change the color of entire rows and columns intersecting the selected cell(s). I am also using Excel2000. Anyone spot any error in this code? Thanks, pac ------------- Private Sub Worksheet_SelectionChange(ByVal target As Range) Rows.Interior.ColorIndex = 0 target.EntireColumn.Interior.ColorIndex = 36 target.EntireRow.Interior.ColorIndex = 37 Debug.Print target End Sub ------------- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change color of entire row by use conditional format | Excel Worksheet Functions | |||
change first letter of a word for an entire column | Excel Discussion (Misc queries) | |||
Change font color across entire row | Excel Discussion (Misc queries) | |||
If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
Color Entire Rows depending on Text in Column A | Excel Programming |