Bernie Deitrick
12/12/2006 2:49:00 PM
R,
Worksheet("Sheet Name").Range("A:A").Copy Worksheets("Other Name").Range("A:A")
Worksheet("Sheet Name").Range("B:B").Copy Worksheets("Other Name").Range("D:D")
Worksheet("Sheet Name").Range("C:C").Copy Worksheets("Other Name").Range("G:G")
HTH,
Bernie
MS Excel MVP
"RSteph" <RSteph@discussions.microsoft.com> wrote in message
news:552F30C2-AA50-4B68-82F2-7330575C7F81@microsoft.com...
> Is there a quick and dirty way to copy an entire column from one worksheet,
> and paste it into another (with a macro). For example I have a worksheet with
> three columns. I'd like to paste column A of that worksheet into column A of
> another, then column B into column D, and column C into column G.
>
> As of now I'm using a for loop to run through the first worksheet, and then
> doing a simple Cell("").Value = worksheet.Cell("").Value type of deal; but I
> was curious if there was a simpler way to handle this: Some sort of
> 'worksheet(1).Columns("B").CopyTo(Worksheet(2).Columns("D")' - Something
> simple like that??
>
> Is there and easier/more effecient way to handle this than to use a For Loop?