title: Dynamic Named Range with Moving Data Below
body: <p>I am trying to create a dynamic named range that I can use for a data validation list. I use these all time but in this case I have information that is housed below the range that cannot be counted in the range. Also, I have a macro that insert rows within this range that do need to be counted.</p>
  
  <p>I normally would use something like this if nothing else was in the column: =OFFSET($A$1,0,0,COUNTA($A:$A),1)</p>
  
  <p>I need to start this one down the page a little ways so I used:
  =OFFSET($A$24,0,0,COUNTA($A$24:$A24),1)</p>
  
  <p>Notice I have removed the "$" before the last "24" in the formula hoping it would expand accordingly, but that does not seem to be consistent.</p>
  
  <p>Basically, I need the COUNTA range to only include a range of cells that will always be growing and shrinking. </p>
  
  <p>I'm not bad in VBA and am open to a solution that might include looping through a range of cells and stopping once it reaches a cell that's value equals a certain text string (in the case in would be .Value = "Request 1"). But I am a little apprehensive about feeding a form or ActiveX Control, as this has caused me issues in the past with viewing and printing functionality. </p>