Identifying Current Cell

[kaayyes]

Hi

Can someone help me to know how to locate the current active cell using
color banding highlight the row and column (like a cross-wire)

 

[Mike H]

Try Chip Pearson's row liner:-

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

Mike

 

[Stanley]

Hi Mike,

This is great.... but, few more questions:

1. Instead of having it by line, would it be possible to mark the row and
column with colors banding instead?

2. I have downloaded this and use it. That is ok. But, after I close
it, and re-open a new Excel, it is not there anymore. I have always to open
this first. If in case, I download from ERP system an Excel output, then how
can I ensure that, this is already built in there for me?

Thanks.
stanley

 

[Mike H]

It an add-in so:-

Tools|addins|browse

navigate to where you saved it and click OK. If you ensure rowliner is
checked in the addins box it will be there when you start up.

With regard to highlighting the entire row/column then that would be a
change to the code or you could try this pasted in as worksheet code.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static LastChange
Application.ScreenUpdating = False
If LastChange = Empty Then
LastChange = ActiveCell.Address
End If
Range(LastChange).EntireColumn.Interior.ColorIndex = xlNone
Range(LastChange).EntireRow.Interior.ColorIndex = xlNone
ActiveCell.EntireColumn.Interior.ColorIndex = 15
ActiveCell.EntireRow.Interior.ColorIndex = 15
LastChange = ActiveCell.Address
Application.ScreenUpdating = True
End Sub

Mike

 

[Stanley]

Thanks, Mike. This is very useful.
I copied and save it as .xla.
I have added it in the adds-in box.
But, when I open a new excel, this functionality is not available.
How can I make this available for any Excel file opened ?

Thanks.
stanley

 

[Mike H]

Stanley,

It already was a .xla file and if you have navigated to it from the addins
box it should be available evry time you start Excel. If you are using it by
running rowliner.xla (by double clicking it) then you are doing it
incorrectly and it won't be available when you start Excel.

Mike

 

[#DIV/0]

Anyone know how to get round the following known issue with this add-in -
"RowLiner will not draw lines in split windows or frozen panes" ?

 

[Mike H]

Chip Pearson notes this limitation on his website and if he hasn't fixed it
then it probably isn't going to get fixed.

Mike

 

[Stanley]

Hi Mike

The situation is like this.
I copy the program you have given, and store it. Yes, from Add-Ins, that
option by default is already selected. I can verify from the Macro Visual
Basic, it is there too. But, whenever I open a new excel file, it is not
functioning.

It looks like, it is available there, but it is not activated, kind of.

Thanks.
stanley