Copy and Paste colume using VBA

[hanif]

Hi,

Any idea how can I copy a column from one sheet and paste it to another colume if different sheet using VBA? thanks!

[JieJenn]

Worksheets("Worksheet Name X").Columns(1).Copy Worksheets("Worksheet Name Y").Columns(1)

[hanif]

Do I have to insert it in new module?

Worksheets("Worksheet Name X").Columns(1).Copy Worksheets("Worksheet Name Y").Columns(1)

[JieJenn]

Do I have to insert it in new module? Yes