title: Last cell selection .End(xlup) using VBA in Excel 2003 'lists' - requires two .Select to get correct cell?
body: <p>I'm a new convert from Experts-Exchange since I noticed they increased the 'Free Premium Services' points threshold.  </p>
  
  <p>It seems that Excel 2003 has issues with the End(xlup) command when using it in a worksheet that contains an Excel 'List'.. If I select a cell <strong>outside the 'list' boundary</strong>, and then try to select the last cell in the worksheet by using VBA, I have to call the .Select function twice to make sure I am getting the correct cell.  If the original cell is <strong>inside the 'list' boundary</strong> then i only need one .Select.  My hacked together solution is below, with two selects, as I can never be sure what cell may be selected on save.  I include a version check at open to run different code in Excel 2007 (this code fails in 2007, where the .End(xlUp) command works properly).</p>
  
  <p>Is there a more eloquent way to handle this? 
  Thanks for any help!</p>
  
  <pre><code>.Range("A1").Select
  .Cells(.Rows.Count, "A").End(xlUp).Select
  .Cells(.Rows.Count, "A").End(xlUp).Select
  'two .Selects needed to select correct cell in Excel 2003 list because original selection (A1) was not in list'
  
  .Range("A1").Select
  .Cells(.Rows.Count, "T").End(xlUp)(-2, 1).Select
  .Cells(.Rows.Count, "T").End(xlUp)(-2, 1).Select
  'two .Selects needed to select correct cell in Excel 2003 list because original selection (A1) was not in list'
  
  .Cells(.Rows.Count, "T").End(xlUp)(-3, 1).Select
  'only one select needed here because original selection above was within the list'
  </code></pre>