Hi
I recorded this macro by performing the steps.
I copied a range from workbook1, switched to workbook2, activated record new macro, then edit paste special and ticked "values", ok. Stop recording.
Sub test()
'
' test Macro
' Macro recorded 2015-12-20 by GT
'
'
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
Then, I copy the same range off wb1, switched to wb2, run the macro and got this error.
Any ideas?
Thx
Your macro uses 'PasteSpecial' to paste a 'Selection' but there is no 'Selection' indicated in the macro and there is no destination. I believe that your code would have to look something like this:You need the macro to copy the range and then you need to specify the paste destination. Please note the two different extensions. The "xlsm" indicates that the workbook contains the macro. The macro also assumes that both workbooks are open.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
The thing is that the range copied from WB1 is manually selected and is not fixed. As far as the target, let that be deemed the current active cell on WB2.
In other words, paste special (values) clipboard contents to WB2 current active cell.
In the Visual Basic Editor, click on 'Tools', then click on 'References" and then put a check mark beside 'Microsoft Forms 2.0 Object Library'. Copy your range as usual and then try this macro:If the 'Microsoft Forms 2.0 Object Library' is not visible, add a blank userform to your project and that should make the Object Library visible. You can delete the userform if you wish.Please Login or Register to view this content.
Last edited by Mumps1; 12-20-2015 at 03:19 PM.
Done. Still though
Run-time error '1004':
PasteSpecial method of Range class failed
(If you get it, include a variation for inserting the copied range (shift cells down)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks