Copy Destination Problem

[Ark68]

There is likely an obvious error I can't see ...

With ws_dump
     .Range("A2:A" & f_rowcnt).Copy Destination:=.Range("AA2")
End With

I am simply trying to copy the cell contents, A2:A4, from worksheet ws_dump to cell AA2 in ws_dump.
Why are the 3 cells being copied to AA1:AA3?

 

[DanteAmor]

If you don't put the full code, we'll just guess...

.Range("A2:A" & f_rowcnt).Copy Destination:=.Range("AA2")

How are you filling the variable f_rowcnt?

I am simply trying to copy the cell contents, A2:A4

If you only want to copy A2 to A4, then it should be:

.Range("A2:A4").Copy Destination:=.Range("AA2")

 

[Ark68]

Hi Dante, thanks for your reply. The range to be copied is dynamic, I used A2:A4 only as an example. The range being copied is defined by A2:A & f_rowcnt where f_rowcnt was previously calculated

f_rowcnt = WorksheetFunction.CountA(ws_dump.Columns(1))

This value is being calculated properly.

 

[Ark68]

I think I got it solved. There may have been values in AA1 prior to pasting which made it appear the values were being placed at AA1.
All good after a dded a line to clear that column.