Hello all

I created a module which copy an area of excel cells (e.g. A45:D51).
How can I call this module and use
.ActiveDocument.Bookmarks("bookmarkname") to paste the copied area of
cells into the Active Word document under the bookmark?

If a module is returned a text string, I can use
.ActiveDocument.Bookmarks("bookmarkname").Range.Text =
ModuleThatReturnText

How about the module which has already copied a range in Excel
worksheet and want to paste it under the bookmark?

Cheers
Bon