| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transfer data by defined name
If you know the size of the range:
sheet2.range("C3:C6") = sheet1.range("MyRange") If you don't know the size of the range: For each cell in sheet1.range("MyRange") sheet2.cells(3+cell.row,3+cell.column) = cell.value Next cell |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto transfer data in sheet2 (selected data) | Excel Worksheet Functions | |||
| Transfer Excel data into Word, including text box data | Excel Discussion (Misc queries) | |||
| User defined buttons in Toolbars,transfer to another computer | Excel Discussion (Misc queries) | |||
| Transfer Data from Excel 2000 to the Access data base | Excel Programming | |||
| User-defined data type; Error: Only User-defined types... | Excel Programming | |||
Threaded Mode
