Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Range from 1 sheet to next
Hi,
I am trying to copy a range of cells (A1:C3) from Sheet 1 to Sheet 2 The code below doesn't work, can anyone assist, Thanks Sub cop() Dim i, j For i = 1 To 3 For j = 1 To 3 Sheets("Sheet1").Cells(i, j).Copy Sheets("Sheet2").Paste Cells(i, j) Next Next End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Range from 1 sheet to next
Hi Teresa,
Try: Sheets("Sheet1").Range("A1:C3").Copy Sheets("Sheet2").Range("A1") --- Regards, Norman "teresa" wrote in message ... Hi, I am trying to copy a range of cells (A1:C3) from Sheet 1 to Sheet 2 The code below doesn't work, can anyone assist, Thanks Sub cop() Dim i, j For i = 1 To 3 For j = 1 To 3 Sheets("Sheet1").Cells(i, j).Copy Sheets("Sheet2").Paste Cells(i, j) Next Next End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Range from 1 sheet to next
Worksheets("Sheet1").Range("A1:C3").Copy _
Destination:=Worksheets("Sheet2").Range("A1") -- Regards, Tom Ogilvy "teresa" wrote in message ... Hi, I am trying to copy a range of cells (A1:C3) from Sheet 1 to Sheet 2 The code below doesn't work, can anyone assist, Thanks Sub cop() Dim i, j For i = 1 To 3 For j = 1 To 3 Sheets("Sheet1").Cells(i, j).Copy Sheets("Sheet2").Paste Cells(i, j) Next Next End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Range from 1 sheet to next
Thanks a lot guys - you've been very helpful
"Tom Ogilvy" wrote: Worksheets("Sheet1").Range("A1:C3").Copy _ Destination:=Worksheets("Sheet2").Range("A1") -- Regards, Tom Ogilvy "teresa" wrote in message ... Hi, I am trying to copy a range of cells (A1:C3) from Sheet 1 to Sheet 2 The code below doesn't work, can anyone assist, Thanks Sub cop() Dim i, j For i = 1 To 3 For j = 1 To 3 Sheets("Sheet1").Cells(i, j).Copy Sheets("Sheet2").Paste Cells(i, j) Next Next End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet. | Excel Worksheet Functions | |||
Copying a range to another sheet | Excel Discussion (Misc queries) | |||
Macro for copying named range to any sheet | Excel Programming | |||
Copying a particular range of values from one sheet to another in excel | Excel Programming | |||
Copying a Filtered Range from a Sheet in another Workbook | Excel Programming |