title: VB.net excel merged cells range
body: <p>I have a Excel spreadsheet that hold some sizes. And I would like to search this file at runtime.</p>
  
  <p><a href="https://i.stack.imgur.com/XB8Hg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XB8Hg.png" alt="Excel sheet"></a></p>
  
  <p>This Sheet contains a table column 1 defines the group within the search must occur. So I will search Column A until I find a cell containing the group I prefer.</p>
  
  <p>This group is a merged cell that contains all the rows that belong to this group.</p>
  
  <p>My question: How can I get the range of rows consumed by the merged cell? This range is needed to list all available ratings for this group.</p>