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.

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.

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