Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macros and non-contiguous copying
Is there a way to set up a macro to copy data in non-contiguous columns?
Example: The data source has information in columns A, B, C, and D--I only want to copy columns A, C, and D to my Excel worksheet. How would I move down to the next row and perform the same actions for this row of data? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macros and non-contiguous copying
Sub copycols()
Range("a1,c1:d1").EntireColumn.Copy End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Bradly" wrote in message ... Is there a way to set up a macro to copy data in non-contiguous columns? Example: The data source has information in columns A, B, C, and D--I only want to copy columns A, C, and D to my Excel worksheet. How would I move down to the next row and perform the same actions for this row of data? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying non-contiguous formulas | Excel Discussion (Misc queries) | |||
Copying and pasting with macros | Excel Discussion (Misc queries) | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
copying macros | Excel Worksheet Functions | |||
copying macros | Excel Worksheet Functions |