Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying across columns
Hi,
I have the following sample code which keeps creating an error, please can you tell me whats wrong? the columns to copy need to be in that order. With oldbk.Sheets(2) ..Columns("H:H,T:T,AK:AK,G:G,AJ:AJ,D:D,AM:AM,AP:AP ,AS:AS,AU:AU,AQ:AQ").Copy Destination:= _ NewbkS2.Range("A1") End With thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying data down columns | Excel Worksheet Functions | |||
Copying to columns | Excel Discussion (Misc queries) | |||
Copying One column into Two columns | Excel Discussion (Misc queries) | |||
Copying from columns to Rows | Excel Discussion (Misc queries) | |||
copying columns | Excel Discussion (Misc queries) |