URGENT: Excel VBA Paste Special Code

I'm trying to create code in Excel VBA that will allow user to copy a range of cells from another workbook, then using what is copied, paste-special the copied range (as values only) to a specified cell on the activesheet in another workbook. This seems simple, but the clipboard is being cleared by VBA when specifying the paste destination. Needs to be compatible with Excel 2007 and 2010. Sample code that I'm having problems with is below. Most consistent error is "Runtime Error '1004': PasteSpecial method of Range class failed." NEED VERY QUICK COMPLETION FOR THIS PROJECT. Thank you!!

Sub PasteQBOData()

[url removed, login to view]("A7").Select

[url removed, login to view] Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=False, Transpose:=False

End Sub

Compétences : Excel, Visual Basic

en voir plus : excel 2010 vba pastespecial, vba pastespecial, vba excel 2010 paste special, excel 2010 vba 1004 pastespecial, excel vba paste special, excel vba paste special code, paste special vba code, excel paste special code, vba pastespecial code, paste special method vba, vba paste special, vba paste destination, excel vba pastespecial, excel vba pastespecial error 1004, excel 2007 vba pastespecial, excel 2010 vba pastespecial 1004, excel 2010 vba copy paste special, excel 2010 pastespecial, excel vba special paste error 1004, vba excel pastespecial, vba error 1004 excel 2007 pastespecial, vba 2010 paste special range method, vba copy paste special 1004 error, vba paste special workbook, excel 2010 vba pastespecial skipblanks

Concernant l'employeur :
( 5 commentaires ) Lawrence, United States

Nº du projet : #1084353

Décerné à:


Hi, Excel VBA expert here ready to fix this up immediately. Please check PM for details. Thanks!

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 0 jours
(64 Commentaires)

3 freelance font une offre moyenne de $30 pour ce travail


Hi, send me please both books if possible, I did this many times and so I think I'll be able to help you. Thank you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(26 Commentaires)

Can start now. Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement. See my previoulsy completed project

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(7 Commentaires)