Hi,
I am using the below code to highlight a selected row in a table by referencing the number in cell A11 and conditional formatting the table.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("B8:L19")) Is Nothing Then
Range("A11").Value = Target.row
End If
End Sub
What i am wanting to do however is make the end of the table dynamic as the table will grow over time so new rows need to also highlight when selected.
Does anyone have an idea how to best do that please?
Thanks for any help given![]()
Bookmarks