Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Intersections
Hi, Is there any way in which I could click in any cell on a workbook and the column would highlight up to that cell, and the row would also highlight up to that cell? It's something that might make data entry a lot easier when viewing a couple of documents at the same time! Dan. -- Voodoodan ------------------------------------------------------------------------ Voodoodan's Profile: http://www.excelforum.com/member.php...nfo&userid=597 View this thread: http://www.excelforum.com/showthread...hreadid=395322 |
#2
|
|||
|
|||
You could try something like this, Dan:
http://www.cpearson.com/excel/RowLiner.htm ************ Anne Troy www.OfficeArticles.com "Voodoodan" wrote in message ... Hi, Is there any way in which I could click in any cell on a workbook and the column would highlight up to that cell, and the row would also highlight up to that cell? It's something that might make data entry a lot easier when viewing a couple of documents at the same time! Dan. -- Voodoodan ------------------------------------------------------------------------ Voodoodan's Profile: http://www.excelforum.com/member.php...nfo&userid=597 View this thread: http://www.excelforum.com/showthread...hreadid=395322 |
#3
|
|||
|
|||
Try putting this in ThisWorkbook module:
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Sh.Cells.Interior.ColorIndex = xlNone If Target.Cells.Count = 1 Then With Rows(Target.Row).Interior .ColorIndex = 6 .Pattern = xlSolid End With End If If Target.Cells.Count = 1 Then With Columns(Target.Column).Interior .ColorIndex = 6 .Pattern = xlSolid End With End If End Sub "Voodoodan" wrote: Hi, Is there any way in which I could click in any cell on a workbook and the column would highlight up to that cell, and the row would also highlight up to that cell? It's something that might make data entry a lot easier when viewing a couple of documents at the same time! Dan. -- Voodoodan ------------------------------------------------------------------------ Voodoodan's Profile: http://www.excelforum.com/member.php...nfo&userid=597 View this thread: http://www.excelforum.com/showthread...hreadid=395322 |
#4
|
|||
|
|||
Good afternoon Voododan It's certainly possible, although there are issues with running code that is constantly updated in that this would constantly clear the undo stack - if you make a mistake, there is no undo facility to fall back on. Chip Pearson provides a routine to run to do this he http://www.cpearson.com/excel/excelM...ightActiveCell Although he has written an add-in that's much more enhanced - and free, so try that. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=395322 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|