How to detect if cells text go on other column ?

A

Alex St-Pierre

Hi,
I copy an paste a table from excel to word. If cells are merged or text go
to an other column in excel, Word will merged theses cells. I would like to
find a way to know if the cells has been merged in Word ?

Example: if the table has 3 columns in excel and column 1 and 2 are merged.
Cells(1,3) in excel will refer the column #3 in excel but cells(1,2) in Word
will refer to the same column. So, I could add a vector:
myVector(1) = 1
myVector(2) = 3
In Word, I will say:
For i = 1 To tbl.Rows.Count 'word table
For j = 1 To tbl.Rows(i).cells.Count
tbl.Cell(i, j).Value = rngExcel.Cells(i, MyVector(j)).Value
Next j
Next i

How can I create MyVector(i) ? Does anyone know how to detect if a cell go
to an other column.

Thanks !
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top