=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, then look at the syntax.
> > > Dave.
>
> > > > Da
alse, 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, then look at the syntax.
> > Dave.
>
> > > Dat
der 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
>
&
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: exce
This is something that seems pretty simple, I am trying to paste
values into a workbook using a macro:
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues
I start out by manually copying a range of cells in a separate
workbook and clicking a form button to paste the values. Each time
