I'm attempting to change the focus when you select a cell. This is what I have thus far, but it is not working. Any suggestions?
![]()
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = Range("Template!C18").Address Then Dim rng As Range Set rng = Range("Ranges!C2") Range(rng.Value).Select End If End Sub
Bookmarks