title: How to get a radio button or sheet macro to use relative references
body: <p>Okay so attached below is the code I have so far and I have no idea what I'm doing. I wanted to use a radio button to add or subtract from the on hands in the same row... but couldn't figure out how to actually tie it down to a cell. So what I have decide is to just fill E2-E450 and F2-F450 with a &quot;+&quot; or &quot;-&quot; sign respectively. I want it to be that when you click E2 it adds + 1 to D2 or when you click F3 it subtracts one from D3 and so on and so forth.</p>
  <pre><code>Sub MyMacro()
  Range(&quot;D2&quot;).Select
  ActiveCell.FormulaR1C1 = Range(&quot;D2&quot;) + 1
  End Sub
  
  
  Sub MyMacro2()
  Range(&quot;D2&quot;).Select
  ActiveCell.FormulaR1C1 = Range(&quot;D2&quot;) - 1
  End Sub
  </code></pre>
  <p>And then for the sheet this is what I have</p>
  <pre><code>Option Explicit
  Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  
      If Selection.Count = 1 Then
          If Not Intersect(Target, Range(&quot;E2&quot;)) Is Nothing Then
              Call MyMacro
          End If
      End If
  
      If Selection.Count = 1 Then
          If Not Intersect(Target, Range(&quot;F2&quot;)) Is Nothing Then
              Call MyMacro2
          End If
      End If
      
  End Sub
  </code></pre>