Hello,
I am trying to use "Record a Macro" to select a range in my excel spreadsheet and paste it into an word doc. That word doc is an object within my spreadsheet.
The macro opens the word doc but doesn't paste the excel content. Can't get my head around why it wont paste. I'm very new to macros and VBA. Please help thanks
Sub Letter()
'
' Letter Macro
'
' Keyboard Shortcut: Ctrl+Shift+L
'
Range("F64:F112").Select
Selection.Copy
ActiveSheet.Shapes.Range(Array("Object 1")).Select
Selection.Verb Verb:=xlPrimary
End Sub
I am trying to use "Record a Macro" to select a range in my excel spreadsheet and paste it into an word doc. That word doc is an object within my spreadsheet.
The macro opens the word doc but doesn't paste the excel content. Can't get my head around why it wont paste. I'm very new to macros and VBA. Please help thanks
Sub Letter()
'
' Letter Macro
'
' Keyboard Shortcut: Ctrl+Shift+L
'
Range("F64:F112").Select
Selection.Copy
ActiveSheet.Shapes.Range(Array("Object 1")).Select
Selection.Verb Verb:=xlPrimary
End Sub