Hello SkipVought,
Unfortunately, I still didn't solve the problem. I managed to merge cells for two rows, but still doesn't work for 3 and more.
I attached word document with tables before and after merge.
My code that works for two rows :
I have 2 arrays
1. mergecell[(1,1),(1,4), .. ...
2...
SkipVought,
I think that I also have to check whether whole row was already merged before adjusting row index.
Is there maybe easier and FASTER way to do it?
I run through my array of cells and subtract 1 from every column that is located to the right of my current merged column only when detected horizontal merge (mergeFrom.row = mergeTo.row)
The same I do for rows.
Thanks SkipVought
Yes, I'm coding in VB6 , but suggested asking my question on VBA forum instead of VB6
I'm adjusting my array indexes for row and column in my array, but can't get it to work properly. Works fine only for two row and very very slow.
Hello,
I need to merge table header cells horizontally and some vertically from my VB6 program. The problem is that after merging first 2 cells indexing of other cells changes. So, after merging cell(1,1) and cell(1,2) the original cell(1,3) changes to cell(1,2). I have some headers with 3-4...
Hello,
I need to merge table header cells horizontally and some vertically. The problem is that after merging first 2 cells indexing of other cells changes. So, after merging cell(1,1) and cell(1,2) the original cell(1,3) changes to cell(1,2). I have some headers with 3-4 rows and about 10...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.