View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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.