PDA

View Full Version : Copying multiple ranges to Word



morganth
12-13-2016, 07:08 AM
Hi there, sorry if this has been answered somewhere else - I am a bit of a newbie at VBA and can't find the answer elsewhere.

I have data in 3 worksheets, all in one book. I want to automate copying the print area from each tab into a new word document - they have different formatting so I want them to be separate tables in the word document, with some text between each.

I want to have the document begin with the print area of "Briefing Note 1", then print area of "Schedule", and finally the print area of "Set Up".

Any help would be really appreciated, going crazy trying to do it! :banghead:

Thanks