View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Slagle[_3_] Rob Slagle[_3_] is offline
external usenet poster
 
Posts: 3
Default Copying Range Names and values from one tab to another

I want to be able to copy a range name and value from one tab to
another, how would I be able to do this?


I have tried:

Sheets("sheet1").Range("range1").value =
Sheets("sheet2").Range("Range1").value

and it bombs.

Thanks,

Rob