Hi all,

I have named a range of cells on one worksheet, say I called (A1:B10) as
"My_Range" on "WorkSheet_1".

And then I got another worksheet which want to copy the same value on
another worksheet "WorkSheet_2" using the name as a reference. How could I do
this?

Also, could I specify a particular value inside the named range? For example
how could I display the B3 cell in "My_Range"?

Thanks for your help.

Derek C