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
|