Maybe you can make use of this... right click the tab at the bottom of the worksheet that you want this functionality on, select View Code from the popup menu that appears and then copy/paste the following into the code window that opened up...

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Union(Target.EntireColumn, Target.EntireRow).Select
Target.Activate
End Sub

Now, go back to the worksheet and double click any cell and both its row and column will become highlighted. The only downside to this method is if you have "Move Selection after Enter" enabled... hitting the Enter key will still move the selection, but not the highlight... you need to do a regular mouse click anywhere on the grid to remove the highlight or simply double click another cell to move the highlight to it.

--
Rick (MVP - Excel)


"Doug" wrote in message ...
Is their a view code that i can use to make the pointer show a line down the
screen? this would be very helpful when viewing chart data.
--
Thank you!