View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Brian Taylor Brian Taylor is offline
external usenet poster
 
Posts: 52
Default 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