title: Passing through variable to sub in VBA
body: <p>This is probably very basic, but I have tried so many things and the always give errors.</p>
  
  <p>Basically what I'm trying to do is run a procedure every time a cell gets changed in Excel. So I'm using Sub Worksheet_Change(ByVal Target As Range).
  All works well, but in this procedure, I'm calling another sub procedure several times.</p>
  
  <p>I want to reuse the 'Target' value in this procedure, but for some reason, I can't find how to do it. I tried placing 'Public rTarget As Range' and do a 'rTarget = Target' at the beginning of the procedure. But the rTarget stays empty when I call the sub procedure.</p>
  
  <p>How do I make this work?
  I'm now adding Target as one of the variables to to subroutine, but that just looks stupid.</p>
  
  <p>Thanks!</p>