referring to a range

K

Kevin Smith

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
 
I

Iain King

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.
Click to expand...

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
 
Top