Copying range of cells to a bookmark in word

**wonderdunder** · 11-09-2010, 10:56 AM

I'm using the following code to paste information from excel to word:

Please Login or Register  to view this content.

It works absolutely fine. however I have a range of cells (B2:H40 which is essentially a table) which I have tried pasting in the same fashion (...range.text = ....range(B2:H40)) with no luck - I get a run type error 13 - Type Mismatch.

The bookmark in questions is at the beginning of the second page of Word, so I have tried using wdgotopage function but I don't know how to use it.

Anyone have any ideas on how to solve this?

**fredblogs** · 11-09-2010, 11:03 AM

I might be barking up the wrong tree but have you got quotes around the range? ie Range("B2:H40")

**fredblogs** · 11-09-2010, 11:04 AM

Apologies Just realised that was code:

Please Login or Register  to view this content.

**wonderdunder** · 11-09-2010, 11:07 AM

Sorry - my message is a bit messy. The brackets and quotes are there!

It doesn't seem to like having a range of cells being put to a bookmark (which does work as when I try and use just one cell, it works fine).

**wonderdunder** · 11-10-2010, 03:25 AM

I've tried recording a macro but that doesn't work

Anyone have other ideas or code?

**wonderdunder** · 11-11-2010, 05:07 AM

I've found on another forum that a range can be set as Dim [rangename] word.range.

Problem is I can't figure out how to use it. I've got this so far:

Please Login or Register  to view this content.

Now how do I get the cells B1: I40 to paste? (wdDoc is already set).

Thanks.

**royUK** · 11-11-2010, 05:12 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here