What does you code look like where you copy a cell (or range of cells)
from the source?
Thanks
David
On Dec 1, 8:01 am, excelCPA wrote:
> I have tried recording it manually using a macro as Dave suggested and
> the code Deepak suggested with no luck.
>
> Here's the weird part, if the source is a
I have tried recording it manually using a macro as Dave suggested and
the code Deepak suggested with no luck.
Here's the weird part, if the source is anything other than another
Excel workbook, the past special code works fine. For example if I
copy something out of Word, IE, Outlook, or even th
Hi,
Please try this code, Hope this will help.
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Regards,
Deepak Rai
On Tue, Dec 1, 2009 at 10:03 AM, Dave Bonallack
wrote:
> Hi,
> Try doing it manually with the macro recorder on, the
Hi,
Try doing it manually with the macro recorder on, then look at the syntax.
Dave.
> Date: Mon, 30 Nov 2009 10:05:31 -0800
> Subject: $$Excel-Macros$$ Run-time error '1004': PasteSpecial method of Range
> class failed
> From: jon.wester...@gmail.com
> To: excel-macros@googlegroups.com
>
>
