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!!
[url removed, login to view]("A7").Select
[url removed, login to view] Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
Đã trao cho:
3 freelancer đang chào giá trung bình $30 cho công việc này
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