copy method of range object
 

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

copy method of range object
 

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?

copy method of range object
 

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?