Highlight a row

U

Ultimate

I want to be able to pick any cell on a particular sheet and have the
whloe row that it is in change to a a highlight or specific color. any
help would be appreciated. thanks.
 
R

RagDyer

This page of Chip Pearson's might interest you.

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I want to be able to pick any cell on a particular sheet and have the
whloe row that it is in change to a a highlight or specific color. any
help would be appreciated. thanks.
 
B

BrianB

You may find that this is not exactly what you want, but I leave you t
sort that out <<grin>>.

'-----------------------------------------
Sub highlight()
With ActiveCell.EntireRow.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End Sub
'-----------------------------------------
 
Top