Copying Range Names and values from one tab to another

  • Thread starter Thread starter Rob Slagle
  • Start date Start date
R

Rob Slagle

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro needs updated Range name addresses 3
NamedRange - Variable Sheet 1
Activecell range copy 3
How to replace cells by (predefined) ranges 1
Range(sheet2) = Range(sheet1) 11
problem returning a range from a function 7
copying and pasting range problem 1
SumProduct basics 3

Back
Top