copypaste problem

[ndendrinos]

this works

Sheets("Records").Range("columns").Copy Destination:=Sheets("Statement").Range("A1")

but when I change the range to

Sheets("Records").Range("columns").Copy Destination:=Sheets("Statement").Range("A5")

it does not ...(copy area paste area not the same...)

There are no merged cells copied ... so what is the problem?
Thanks

 

[Simon Lloyd]

So why wouldn't the dynamic range work for you?
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)

 

[ndendrinos]

Hello Simon,

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)

this way I use for other named ranges in this WB. What I hope to learn is how to apply this concept to cover multiple columns (non contiguous)

 

[Simon Lloyd]

Sorry you completely lost me there!

 

[ndendrinos]

not surprising Simon ... I was born that way.
If the named range is like this:

=Sheet1!$A$A,Sheet1!$C:$C,Sheet1!$O:$O

how can I make it "dynamic" so that it will only copy what rows are populated within the columns?