title: Last Row in Range
body: <p>Having an issue finding information and/or solutions that produce the desired result, so here it goes.</p>
  <p>Right now, and potentially at production time, i will have a &quot;template&quot; named-range on a worksheet.  On first use this NamedRange is only <code>rngNamed1</code> but after the first use there could be more Named Ranges similar to this one, say up to <code>rngNamed30</code>.</p>
  <p>Lets say on the 2nd run after building up to <code>rngNamed30</code>, that i need to add 3 more of the NamedRange, which results in <code>rngNamed33</code>.</p>
  <p>What i need to do is basically find the last row &amp; column of the last Named Range, so i know where to start the copying of data to and declare the next Named Range.</p>
  <h3>What i have tried so far:</h3>
  <pre><code>Dim rng As range
  Set rng = range(&quot;rngNamed1&quot;)
  'Set rng = rng.Find(&quot;*&quot;, rng.Cells(1, 1), xlFormulas, xlPart, xlByRows, xlPrevious, False)
  Debug.Print rng.Find(&quot;*&quot;, rng.Cells(1, 1), , , , xlPrevious).Address
  </code></pre>
  <p>The problem with most of the solutions out there is they are based on finding the last cell WITH DATA.  I just need to know the Last Cell of the Range, irregardless of whether it contains data or not.</p>