Right now I have code setup so if a 1 is entered into a cell in Column A the active cell is made then made Cell C2. I want to change it so that it is a specific cell (A50) instead of the entire column.
Here is the code that does it now:
If avoidloop And Trim(Target) <> "" Then
If Target = "1" Then
Range("C2").Select
Application.SendKeys "{F2}"
Else
Bookmarks