Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how create cursor that highlights total row/column at all times
how do i create a cursor that at all times highlights the row/column that i
am working in? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how create cursor that highlights total row/column at all times
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 wrote in message ... how do i create a cursor that at all times highlights the row/column that i am working in? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiply hours/minutes times dollars for total dollar amount | Excel Discussion (Misc queries) | |||
sum of total hours not correct | Setting up and Configuration of Excel | |||
How do i get excel to add a range of times & display as total as . | Excel Discussion (Misc queries) | |||
How do I sum times to get a total hour value? If I add up to 24 h. | Excel Discussion (Misc queries) | |||
Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) |