Run-Time Type 13 Mismatch Error help - Excel VBA

[ShakJames]

Hi all,

Some help would be much appreciated. I'm getting a type mismatch error on the below code and I was wondering if anyone could see why I am getting it. I can't seem to see an error myself - I've highlighted the error point.

Please Login or Register  to view this content.

A bit background on what I am trying to do - The above transfers data from Word to Excel. However, it deletes the Enclosed Bookmark on Word, which I need to keep, so I've added coding to replace the bookmark. That's where the problems have started.

Any help would be much appreciated.

Thanks,

[Norie]

Change the declaration of BMRange to Object.

[Kyle123]

Try changing:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

[ShakJames]

Thank you both. That's worked a treat. On a side note, can I ask why it needed to be Object rather than range?

[Kyle123]

Because since you are running this in Excel, a Range is an Excel Range, you can't assign a word range to an excel range, they're completely different things

[ShakJames]

Cheers for that. I'll pocket that away for future reference.