Hi, I am using this great little piece of code that I got from this site to highlight the active row I am on:
But I tried applying to other sheets in the workbook and it does not work, the sheets I am trying to apply this to that are contained in the same workbook are "Credit_Pulls", "Applications", "Fundings", and "Current_Pipeline".
Can someone help me tweak to make it work?
Automatically Highlight Active Row in Excel
I use Excel… a LOT, and for a very long time! With that comes the inevitable… my eyes aren’t as young as they used to be… plus, we tend to have a TON of data in our Excel fi…
lifehacks365.com
But I tried applying to other sheets in the workbook and it does not work, the sheets I am trying to apply this to that are contained in the same workbook are "Credit_Pulls", "Applications", "Fundings", and "Current_Pipeline".
Can someone help me tweak to make it work?
VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With ThisWorkbook.Names("HighlightRow")
.Name = "HighlightRow"
.RefersToR1C1 = "=" & ActiveCell.Row - 4
End With
'End Sub
With ThisWorkbook.Names("HighlightRowCredit")
.Name = "HighlightRowCredit"
.RefersToR1C1 = "=" & ActiveCell.Row
End With
End Sub