Use Word vba to copy a range from Excel into Word

[tomfabtastic]

Hi,

I would like to use Word vba to copy a range from Excel into Word:

'oWB is the open excel worksheet
'Copy the range
oWB.Worksheets("Sheet1").Range("$BZ$3:$CG$77").Copy

'Now paste into word
Selection.Range.PasteAndFormat wdChartPicture

However, this actually pastes as a Table.

I want the excel range to look like it would if you manually:
1) copied it in Excel
2) in Word, Paste special (picture - enhanced metafile)

Any ideas ?

Thanks,
Tom