| 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 |
| 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 | |||
Threaded Mode
