Hi Everybody
Using VBA I am exporting Excel data into a new Word doc as a Word Table - OK
Due to merged cells in Excel the resulting Word Table has different column widths.
As a result I can't do (VBA) Column formatting in the Table.
I have tried .Split(ting) the merged rows to get the same number of columns but the resulting column widths are distributed equally in the row giving another set of widths.
I can .SetWidth(s) of individual cells but this is very tedious.
Is there a way of setting the width of all columns the same without doing each individual cell so that I can format Columns - or - what other options do I have?
I don't particularly want to un-merge the cells in Excel before exporting.
Any help gratefully received - thank you
barry
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks