title: VBA: Find last row in a fixed number of ranges
body: <p>I tried for a few hours to search and look for a possible answer. I am about ready to give up. I haven't been able to find someone with a scenario quite like the one I am asking, maybe I overlooked it.</p>
  
  <p>I want to find the last row in a specific range. The ranges are <code>A7</code> to <code>A21</code>. I want to be able to enter input data from my form to the empty row within that range...</p>
  
  <p>Here is where it gets tricky. I also have two other categories on the same sheet where I need to input data. Data may already be here, again I want to find the last row and then input data. Ranges <code>A27:A41</code>.</p>
  
  <p>And the last category ranges <code>A46:A66</code>.</p>
  
  <p>Hopefully someone here can help me out.</p>