how do i create a cursor that at all times highlights the row/column that i
am working in?
how do i create a cursor that at all times highlights the row/column that i
am working in?
Copy the code below, right click the sheet tab, select "View Code" and paste
the code into the window that appears. This will work when you are arrowing
around the sheet, or using your mouse. It won't work if you hit enter to
change the activecell.
HTH,
Bernie
MS Excel MVP
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
Union(Target.EntireColumn, Target.EntireRow).Select
Target.Activate
Application.EnableEvents = True
End Sub
"just me" <just me@discussions.microsoft.com> wrote in message
news:F063E6F7-17FE-4AE5-A2DC-F67DC2728575@microsoft.com...
> how do i create a cursor that at all times highlights the row/column that
> i
> am working in?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks