Use Activecell.column to copy

Hi,

For example, my range is C2.

If i set my current column like:

Mycolumn = ActiveCell.Column

Mycolumn would be C

If i would like to copy Range C2:C37, so Mycolumn2:mycolumn37.

How should i program this?