How to get the combined rows of a column with interop

Navigation
0

I would like to obtain the value of the rows that are combined from a given column, I leave an image of an example of a combined column in Excel

The result I want to obtain is for example:

A3: A11, that is to say that in that range I have combined cells, I am working with InterOp and vb .net.

    
asked by Julio Moreno Dev 28.02.2017 в 00:34
source

1 answer

2

If you want you can get the number of cells, rows or columns that are combined. 

  Dim numeroColumnas As Integer = eHoja.Range("A3").MergeArea.Columns.Count
  Dim numeroFilas As Integer = eHoja.Range("A3").MergeArea.Rows.Count
  Dim numeroCeldas As Integer = eHoja.Range("A3").MergeArea.Count
    
answered by 18.03.2017 / 22:07
source
Show information FireBase How to make a multiple select in django