Runtime Error 1004 : Pastespecial Method of Range Class Failed when running excel macro from display macro box

Asked Feb 24 '17 at 05:34

Active Feb 24 '17 at 17:52

Viewed 1,190 times

I am currently copying a selection of cells in one workbook and attempting to Pastespecial with Skip Blanks into another workbook (the destination file will be different every time, so I have saved a super simple macro into my Personal.xlsb book for the paste).

When I open the destination file and run the macro through the keyboard shortcut, it works fine. However, when I run it through the Macro display pop-up(ALT+F8) I get the Runtime Error.

Does anyone know why this would be / a way around it?

I am working with a desktop automation software and it can't trigger a macro through keyboard shortcuts, only though the Macro display pop-up sadly.

The code for my paste macro is:

Sub ps()
' Keyboard Shortcut: Ctrl+d
'
    Range("A2").Select
    Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
        True, Transpose:=False
End Sub

Thanks in advance, Ruby

asked Feb 24 '17 at 05:34

Ruby.Smith

1

replace `Range("A2").Select` with `Range("A2").Copy` if you want copy A2 to the selected field. – VBA Pete Feb 24 '17 at 05:59
@VBAPete Why don't you post your comment as a solution / answer? – Ralph Feb 24 '17 at 10:23
@Ralph because it is not a real answer, just a small fix. – VBA Pete Feb 24 '17 at 14:27

Runtime Error 1004 : Pastespecial Method of Range Class Failed when running excel macro from display macro box

0 Answers0