title: Get start range and end range of a vertically merged cell with Excel using VBA
body: <p>I need to find out the first cell and the last cell of a vertically merged cell..</p>
  
  <p>Let's say I merge Cells B2 down to B50.<br>
  How can I get in VBA the start cell(=B2) and the end cell(=B50)? </p>