Posted to microsoft.public.excel.programming
|
|
Highlighting entire row
Hi Escelinen,
See Chip Pearson's highlighting page at:
http://www.cpearson.com/excel/excelM...ightActiveCell
---
Regards,
Norman
"escelinen" wrote
in message ...
Hello everyone,
I know how to change color for the active cell
(ActiveCell.Interior.Colorindex=15) in Worksheet_SelectionChange Sub,
but how can I change the color for the entire row where active cell is
located? And to be more challenging, I want to change default color
back when active cell is out of highlighted row.
--
escelinen
------------------------------------------------------------------------
escelinen's Profile:
http://www.excelforum.com/member.php...o&userid=27966
View this thread: http://www.excelforum.com/showthread...hreadid=475704
|