Use checkboxes to define which sheets to convert to Word

Hi

I need a little more help with the conversion thing....
i have a sheet that was originally built by someone to convert sheets that you select in a userform to PDF, i have tried to adapt this to convert to word, but with my limited know how i'm losing this battle.

Any help here would be appreciated.

i've attached a copy of the sheet with the code i've been trying to mix & match

Word save all selected sheets in one Word doc..xlsm

Thanks Patel

the sheet copies funny though, any way to set it so it copie only the print area?

still not copying correctly

see example

TEST.docx

Hi

I added the doc to illustrate how it copies into word, it does not fit into the pages.

Any advise as to getting it to fit properly in the word pages with the code already provided?

bump no response

Took me a while but i finally figured it out.....

i added th code below..... for those who where interested......

Please Login or Register  to view this content.

yes Patel, buthis is the only way i could get it to copy to word and properly fit the pages in word. it would have been great if i could have it paste as range that could be edited it the word file later, but i was ahving too many problems getting it to fit the page.....

thanks again for all your help Patel, let me know if you find a solution where i can copy as range to word and ahve it fit the page properly..... i want to eat my cake too