stranger123
Programmer
Hi,
In Excel VBA, I failure to paste whole usedrange from a sheet in another workbook onto the sheet in current workbook with adding operation.
......Copy
aRange.PasteSpecial Paste:=xlPasteValues, operation:=xlPasteSpecialOperationAdd
That was working if I copy from the same workbook.
Can you suggest the working code?
Thank you in advance.
In Excel VBA, I failure to paste whole usedrange from a sheet in another workbook onto the sheet in current workbook with adding operation.
......Copy
aRange.PasteSpecial Paste:=xlPasteValues, operation:=xlPasteSpecialOperationAdd
That was working if I copy from the same workbook.
Can you suggest the working code?
Thank you in advance.