Copy Columna A and K from workbook 1 to column A and B workbook 2 1

[stokak]

can't figure out the coding to do this simple copy. want to avoid clipboard if at all possible.
thansk

 

[PHV]

If you can do it manually then simply use the macrorecorder when doing that.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

A starting point:
Workbooks(1).Worksheets(1).Range("A:A,K:K").Copy Workbooks(2).Worksheets(1).Columns("A:B")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886