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

Copying Range Names and values from one tab to another
 

hi,

see the post under xl new users titled Referencing a range of cells by Derek
C made at 1:50am PST. there are several way to do this posted there.

Regards
FSt1


"Rob Slagle" wrote:

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