Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to highlight active row and column?
right click on your sheet tab and paste this into the code module.
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim TheRange As Range Set TheRange = Union(Target.EntireColumn, Target.EntireRow, Target) Application.EnableEvents = False TheRange.Select Target.Activate Application.EnableEvents = True End Sub "rjamison" wrote: I have a very large table and I am hoping to find a way to highligh the current row and coloum somehow to allow a crosshair like look that follows the active cell. The table is a look up table and following the lines can be a pain even with grided shading |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
How do I get row and column of active cell to highlight? | Excel Discussion (Misc queries) | |||
How do I highlight the active row and column headers? | Setting up and Configuration of Excel | |||
How to set highlight for the column&row header of the active cell | Excel Worksheet Functions | |||
How to highlight active row and column? | Excel Programming |