title: Range reference is "Nothing"?
body: <p>I'm trying to write a function to return the next blank row on a sheet to insert input.</p>
  
  <p>The code is at work so I can only summarize. </p>
  
  <p>I do something like <code>Set rng = Range("Data!A" &amp; row)</code> then return the reference. </p>
  
  <p>Through debugging, I determined the range being created is referencing a valid cell location. However, it is returning "Nothing" instead of an empty Range object. I've gone so far as to set that cell's value to " " (a space) prior to returning the Range and setting it back to "" after. </p>
  
  <p>My question is a two-parter:<br>
  (1) why is an empty (cell values) Range reference always returning "Nothing"?<br>
  (2) how do I properly reference an empty cell as a valid Range object? </p>