Need help pasting usedrange in word bookmark

N

nickadeemus2002

Hello all. I keep getting a Runtime Error 13 Type mismatch for th
following code:


code:
--------------------------------------------------------------------------------

Public Sub SendToWord()
Dim CAP As Range
Dim myWord As Word.Application
Set CAP = Sheets("InitialAssessments").UsedRange
CAP.Copy
Set myWord = New Word.Application
With myWord
.Visible = True
.Activate
myWord.Documents.Open _
Filename:="C:\Documents and Settings\chrisv\Desktop\HBC2\Repor
Document\HBC Reporting Document.doc"
With Selection
myWord.ActiveDocument.Bookmarks("InitialAssessments").Select
.Item("InitialAssessments").Range.Text = CAP.PasteSpecia
<-----PROBLEM WITH THIS LINE
End With
End With
End Sub

--------------------------------------------------------------------------------




I am trying to copy a used range in Excel and copy it at the 'Initia
Assessments' Bookmark in Word.

Suggestions??

And as always, thanks for the hel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top