I have a bunch of data in Excel that I would like to copy
and paste into a Word document to create different
tables. I have written a macro in Word to format these
tables once the excel data is copied over.

Is there a way I can use an Excel macro to automatically
select a block of cells, copy and paste into Word, and
activate the Word macro?

Thanks,

Amy