Marty
07-18-2016, 06:23 AM
Hi all,
I tried to figure this out with no sucess.
I can give a range when I want to do my format as table, but my documents dont have always the same total of line. Sometimes i can have 150 lines, sometimes 20 lines. My Macro has been setup on 150 lines but i need to play with it each time. What is the macro formula so it can do the table based on the data on the line so no need to play with it all the time ? Like an autofit table.
I would like also know if there is way that end of columns "F" and "H" it could do a sum, again the total lines is not always the same, so it has to do the calculation based on the end selection of the table.
I have attached my DOC_SAMPLE document that you can try out. Macro name is PL_AX2
Any help is welcome and more than appreciated.
thanks.
I tried to figure this out with no sucess.
I can give a range when I want to do my format as table, but my documents dont have always the same total of line. Sometimes i can have 150 lines, sometimes 20 lines. My Macro has been setup on 150 lines but i need to play with it each time. What is the macro formula so it can do the table based on the data on the line so no need to play with it all the time ? Like an autofit table.
I would like also know if there is way that end of columns "F" and "H" it could do a sum, again the total lines is not always the same, so it has to do the calculation based on the end selection of the table.
I have attached my DOC_SAMPLE document that you can try out. Macro name is PL_AX2
Any help is welcome and more than appreciated.
thanks.