Tom’s Tutorials For Excel: Using the Home key with Scroll Lock
Here are a few navigation tips using the Home key, with or without the Ctrl key, with or without Scroll Lock activated, and with Freeze Panes on or off.
Tom’s Tutorials For Excel: Using the Home key with Scroll Lock
Here are a few navigation tips using the Home key, with or without the Ctrl key, with or without Scroll Lock activated, and with Freeze Panes on or off.
Tom, I’ve an issue.
If I select Row 1, row 20 should highlight, if select 20 row 40 highlight & 20 should be normal.
This in your worksheet module will do what you say you want:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = -4142
Rows(Target.Row + 20).Interior.Color = vbCyan
End Sub