LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Highlighting entire row


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

 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Highlighting Entire Row without the Mouse F. Lawrence Kulchar Excel Discussion (Misc queries) 11 February 6th 09 09:45 AM
Highlighting Entire Row using CF davisk Excel Worksheet Functions 3 November 14th 07 07:05 AM
highlighting entire functions BorisS Excel Discussion (Misc queries) 2 June 22nd 06 02:28 AM
Highlighting an entire row using conditional formatting. SystemHack Excel Worksheet Functions 5 January 27th 06 01:24 AM
Highlighting entire row cursor on John Excel Discussion (Misc queries) 1 January 22nd 06 08:40 PM


All times are GMT +1. The time now is 09:40 PM.

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"