i have this line which copies and pastes in the one statement:

Sheets("AUS-SA_AgeGrp4M").Range("a1:aq" & LRow).Copy
Destination:=Sheets("Sheet2").Cells(1, LCol + 1)

could someone pls suggest what the code would look like to make it paste as
paste special?

--
Peter

Oh, wait, I did this once. Um...here it is. It depends on what special sort
of paste you want to do; if you just want Paste Values, for instance, do it
like this:

Sheets("AUS-SA_AgeGrp4M").Range("a1:aq" & LRow).Copy
Sheets("Sheet2").Cells(1, LCol + 1).PasteSpecial Paste := xlPasteValues

But you can control the other options, too: comments, all-except-borders,
the arithmetic operations, transpose, all that stuff. If you don't already
know where to find the .chm file for VBA/Excel on your machine, it's past
time you found it, created a link to it and brought it up whenever you have
to code: It makes it a lot easier to find stuff like this. Let me know if
this is a mystery to you and I'll give you some pointers; it's an invaluable
documentation guide, much easier to use than your VBE Help option (in my
opinion).

--- "Peter" wrote:
> i have this line which copies and pastes in the one statement:
>
> Sheets("AUS-SA_AgeGrp4M").Range("a1:aq" & LRow).Copy _
> Destination:=Sheets("Sheet2").Cells(1, LCol + 1)
>
> could someone pls suggest what the code would look like to make it paste as
> paste special?

hey bob.
you saved my arse mate!!!
thanks so much.
i am so bad at trying to learn this language.
re
If you don't already
know where to find the .chm file for VBA/Excel on your machine, it's past
time you found it, --

......ys pls!

Peter


"Bob Bridges" wrote:

> Oh, wait, I did this once. Um...here it is. It depends on what special sort
> of paste you want to do; if you just want Paste Values, for instance, do it
> like this:
>
> Sheets("AUS-SA_AgeGrp4M").Range("a1:aq" & LRow).Copy
> Sheets("Sheet2").Cells(1, LCol + 1).PasteSpecial Paste := xlPasteValues
>
> But you can control the other options, too: comments, all-except-borders,
> the arithmetic operations, transpose, all that stuff. If you don't already
> know where to find the .chm file for VBA/Excel on your machine, it's past
> time you found it, created a link to it and brought it up whenever you have
> to code: It makes it a lot easier to find stuff like this. Let me know if
> this is a mystery to you and I'll give you some pointers; it's an invaluable
> documentation guide, much easier to use than your VBE Help option (in my
> opinion).
>
> --- "Peter" wrote:
> > i have this line which copies and pastes in the one statement:
> >
> > Sheets("AUS-SA_AgeGrp4M").Range("a1:aq" & LRow).Copy _
> > Destination:=Sheets("Sheet2").Cells(1, LCol + 1)
> >
> > could someone pls suggest what the code would look like to make it paste as
> > paste special?