ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I get row and column of active cell to highlight? (https://www.excelbanter.com/excel-discussion-misc-queries/240182-how-do-i-get-row-column-active-cell-highlight.html)

chappi

How do I get row and column of active cell to highlight?
 
I want excel to shade the row and column of my active cell. As my active
cell changes, so will the shaded row and column.

Gord Dibben

How do I get row and column of active cell to highlight?
 
Try Chip Pearson's customizable RowLiner add-in for more positve viewing of
selected cell.

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

Note: does not work on a protected sheet.


Gord Dibben MS Excel MVP

On Wed, 19 Aug 2009 13:43:12 -0700, chappi
wrote:

I want excel to shade the row and column of my active cell. As my active
cell changes, so will the shaded row and column.



dlw

How do I get row and column of active cell to highlight?
 
one way:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=145

"chappi" wrote:

I want excel to shade the row and column of my active cell. As my active
cell changes, so will the shaded row and column.



All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com