About Us

Rob Slagle[_3_]

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

FSt1

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES	Bricol	Excel Discussion (Misc queries)	0	July 8th 08 03:54 PM
prevent range names showing at low zoom values in excel	djbz	Excel Discussion (Misc queries)	0	April 5th 06 03:12 PM
Copying a range of values between worksheets	Christopher R. Lee	Excel Programming	2	February 6th 05 09:08 PM
Searching a range and copying values into a new range.... Please help :(	Lancia	Excel Programming	1	September 29th 04 01:08 PM
Copying a particular range of values from one sheet to another in excel	anoop_2000	Excel Programming	2	June 17th 04 03:46 AM

Menu

About Us