Transfer data by defined name
 

Hello,
How do I copy a range of data (defined as "abc") to another worksheet (start
from cell c3, for example) in the same workbook by the Defined Name "abc".

Thanks.

Transfer data by defined name
 

Hi Choo,

Try:

'=============
Public Sub Tester()
With ActiveWorkbook
.Sheets("Sheet1").Range("abc").Copy Destination:= _
.Sheets("Sheet2").Range("C3")
End With
End Sub
'<<=============


---
Regards,
Norman


"choo" wrote in message
...
Hello,
How do I copy a range of data (defined as "abc") to another worksheet
(start
from cell c3, for example) in the same workbook by the Defined Name "abc".

Thanks.

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