referring to a range
 

Hi,
This may qualify as the easiest question you have had but
I'm struggling...

I want a cell in sheet 2 to equal a named range in sheet 1.
I make the cell active then... I don't know how to refer
to it so it just pulls in its value.

Thanks a lot

Kevin

referring to a range
 

in sheet 2 to equal a named range in sheet 1.
I make the cell active then... I don't know how to refer
to it so it just pulls in its value.


do you mean just in the spreadsheet, or in a macro?

in the spreadsheet:
assuming sheet 1 is called 'FOO', and you named the cell 'BAR', then just
set the cell in sheet 2 to be:

=FOO!BAR


if you are using VB, you can refer to it like this:

Sheets("FOO").Range("BAR").Value



Iain King

referring to a range
 

Bloody marvellous. Thanks a lot!

It was in VB, should have said.

-----Original Message-----
in sheet 2 to equal a named range in sheet 1.
I make the cell active then... I don't know how to refer
to it so it just pulls in its value.


do you mean just in the spreadsheet, or in a macro?

in the spreadsheet:
assuming sheet 1 is called 'FOO', and you named the
cell 'BAR', then just
set the cell in sheet 2 to be:

=FOO!BAR


if you are using VB, you can refer to it like this:

Sheets("FOO").Range("BAR").Value



Iain King


.