Copying sheets

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

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

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

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

Quote:

---

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

---

VB Code:

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