ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adjust an Excel table with the width of a Word page (https://www.excelbanter.com/excel-discussion-misc-queries/37682-adjust-excel-table-width-word-page.html)

[email protected]

Adjust an Excel table with the width of a Word page
 
Hol=E0 has todos los Excel users!!

Here is my small problem (way of speaking, because for me it is
an enormous problem, but for you, it is undoubtedly nothing.):

Under Excel, I have a macro that creates several tables on several
sheets (1 table per sheet). This macro selects and copies each table
into a page in Word.

The problem is that the number of columns is variable : at the time of
copying, the table doesn't not fit the width of the Word page.

That's why I'm seeking a way to do the following things :
1) calculate the number of columns of the xls table
2) find the width of each column (by dividing the width of one Word
page by the number of columns)
3) give to each column this specific width.

The column A always has the same width since it contains the wordings
of the lines.

Any help is welcome. Thank you very much by advance.

Bye


[email protected]

Anyone to help me ? Please, please, please....



All times are GMT +1. The time now is 11:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com