En cours

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

Voir plus : excel 2010 vba pastespecial, vba pastespecial, excel vba paste special, 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 2007 vba pastespecial, excel 2010 pastespecial, vba excel pastespecial, vba paste special workbook, pastespecial code, copy paste excel vba, vba pastespecial 2007 2010, paste range vba excel, paste code excel vba, vba pastespecial method 2007, paste special excel vba, paste special vba

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

N° du projet : #1084353

Décerné à :

bharanisrihari

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

30 $ USD en 0 jours
(64 Commentaires)
6.5

3 freelance ont fait une offre moyenne de 30 $ pour ce travail

telemarketing555

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.

30 $ USD en 0 jours
(26 Commentaires)
4.4
vgrichards

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

30 $ USD en 0 jours
(7 Commentaires)
2.8