Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
John - Vanguard
 
Posts: n/a
Default Visual Reference, row and column crosshairs

Does anybody know how to have the row and column change colors as you move
the active cell around the worksheet, like crosshairs for a quick visual
reference.
  #2   Report Post  
Ragdyer
 
Posts: n/a
Default

Check out Chip Pearson's Add-In that does exactly what you're looking for:

http://www.cpearson.com/excel/RowLiner.htm
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"John - Vanguard" <John - wrote in
message ...
Does anybody know how to have the row and column change colors as you move
the active cell around the worksheet, like crosshairs for a quick visual
reference.


  #3   Report Post  
Peter Rooney
 
Posts: n/a
Default

John,

Here's what you need - it will highlight either the row or the column - not
sure about both yet - This is Chip Pearson's code, modified a little bit, so
i don't really take any credit for it! Just remember to paste it into the
code window of the worksheet you want it to work on - not a normal Visual
Basic module!

Cheers

Pete



Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.FormatConditions.Delete
'-------------------------------------------------------------------------
'Comment out one of these two lines to highlight
'either the selected row or the selected column
With Target.EntireRow
'With Target.EntireColumn
'-------------------------------------------------------------------------
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
With .FormatConditions(1)
With .Borders(xlTop)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 10
End With
With .Borders(xlBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 10
End With
End With
.FormatConditions(1).Interior.ColorIndex = 20
End With
End Sub



"John - Vanguard" wrote:

Does anybody know how to have the row and column change colors as you move
the active cell around the worksheet, like crosshairs for a quick visual
reference.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"