Copying sheets

[engnouna]

Hi
I have an excel worksheet wkh1.I want to copy data from THE COLUMN A of wkh1 to the column L of a worksheet wkh2

I use the following code to copy a worksheet and paste it to another worksheet
wksSource.Cells.Copy wksTarget.Cells
how can i copy the column A from wksSource to the Column L of wksTarget

Thanks in advance

[RobDog888]

Record a macro of you performing the task. Then check out the generated odule code and modify as needed. :)

[engnouna]

Well
I tried the code provided by a macro and I applied it into my VB6 code but it didn't work
What I need is to copy the data in column A in sheet1 of my workbook and paste the data into column L in Sheet2 OF the same workbook.
Can anyone help me?
thanks

[si_the_geek]

See the Excel Tutorial link in my signature - it explains how to convert a macro to VB6 code.

[DKenny]

What I need is to copy the data in column A in sheet1 of my workbook and paste the data into column L in Sheet2

Worksheets(1).Columns(1).Copy Worksheets(2).Columns(12)