copy Array, paste in next column- Repeate 2,000 times

[cjc155]

HI all,

I have an array that I need to copy across 2,000 rows. Obviously, would rather not do this manually. Not too familar with vBA but basically would like to create a macro to

Copy Cell A1
Select next column over (B1)
Paste
Repease 2,000 times.


Would seem simple enough but not to sure how to define the variables.

Thanks for the help - C

 

[VoG]

If I understand correctly

Sub silly()
Range("B1:B2000").Value =Range("A1").Value
End Sub