I was trying to copy data from a variety of places (Worksheets, WebPage, Documents) then execute a macro using this data.
I originally tried to copy the data, execute the macro, and then paste the data into an "InputBox". When I pasted it nothing came up.
Next I tried to copy it and paste the data into a cell on the worksheet. When I did this I got the error "Paste method of Worksheet class failed" .
The portion of the macro looked like this.
----------------------------------------
Sub MacroAA()
'
'Copy somethng from a cell before executing this Macro
'Ctrl C
'Then execute this macro
'I get this error
'Paste method of Worksheet class failed
'
Range("D2").Select
ActiveSheet.PasteSpecial
Range("D2").Select
End Sub
-----------------------------------------
Any help in either pasting the data into the spreadsheet or inputting it into a "InputBox" would be appreciated.
Thanks