title: How do I get the size of a merged Excel cell
body: <p>I'm trying to write code in C# to parse a large Excel sheet that wasn't really designed with automation in mind, and it's full of merged cells.  Many times I know the location of one cell, but need to get the text of another cell a few cells away, but those cells may be merged and span multiple normal cells.  How do I get the size of a merged cell in number of cells?  </p>
  
  <p>Also, how can I get the location of a cell a certain number of cells away, when the cells in between are merged?  I tried Excel.Range.Offset, but that seems to be only counting real cells, not merged ones (so if there's a 4-wide merged cell in between, offset 2 will take me to the middle of that cell, rather than the one next to it).</p>