VBA repeating copy/paste if n=32

[cf89]

Hi. I'm a long time lurker but can't find a solution for this one. (I've simplified the ranges below as it's larger ranges I'm copying in practice, but getting the same issue.)

I'm copying a range from one worksheet to another as follows:
Ws1.Range("A1:Ax").Copy Ws2.Range("A:A")

where x is the last row of data.

I've noticed that I use n=32, the copied data is repeated throughout Ws2.Range("A:A"), up to the end of the sheet (e.g. row 1048576). If n is any other number, it's not repeated. For example, if n=10, only A1:A10 in Ws2 will be filled.

Can anyone please tell me what is special about n=32?

Thanks!

 

[Fluff]

There is nothing "magical" about 32, other than it goes exactly into 1048576
You should only specify the 1st cell in the paste range

Ws1.Range("A1:Ax").Copy Ws2.Range("A1")

 

[cf89]

Thank you very much! Think I'd just been lucky (or unlucky really) that none of the numbers of rows I'd been using it for previously go into 1048576, so hadn't noticed the error in my code

 

[Fluff]

Glad to help & thanks for the feedback.