Group:  Microsoft Excel ยป microsoft.public.excel.misc
Thread: In Excel can I automatically highlight the row im working on?

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

In Excel can I automatically highlight the row im working on?
JPAP 29.09.2006 11:03:01
When Im working in excel it shere ay way to automatically highlight the
entire row im currently on? so when I moove the bow to a new row the
highlight moves too?
Re: In Excel can I automatically highlight the row im working on?
"Carim" <carimfam[ at ]yahoo.com> 29.09.2006 11:47:20
Hi,

I am using the following to highlight current activecell ...

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Cells.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 6
End Sub


HTH
Cheers
Carim

RE: In Excel can I automatically highlight the row im working on?
Marcelo 29.09.2006 11:53:01
Hi,

Chip Person has it at:
http://www.cpearson.com/excel/RowLiner.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"JPAP" escreveu:

[Quoted Text]
> When Im working in excel it shere ay way to automatically highlight the
> entire row im currently on? so when I moove the bow to a new row the
> highlight moves too?

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net