MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Column and Row Viewing Help


Posted by Matthew R. Moffat on January 05, 2002 1:07 PM

Is there any way or utility available that will highlight the row and column as I move around the Excel grid? For example if I am in G17 I want Excel to highlight column G and row 17 instead of just G and 17 at the top and side of the column/row. This is helpful if you are using a small font or low magnification and have to validate values in other column of that same row.

Thanks,

Matt


Posted by Tom Urtis on January 05, 2002 2:48 PM

Right click on your sheet tab, left click on View Code, and paste this into the module:

Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Cells.Interior.ColorIndex = -4142
Target.EntireRow.Interior.ColorIndex = 8
Target.EntireColumn.Interior.ColorIndex = 8
End Sub

It will hilite the row and column you are in, with a shade of blue.

Tom Urtis