Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referring to first cell in a range | Excel Discussion (Misc queries) | |||
Formula referring to a dynamic range in a different workbook | Excel Worksheet Functions | |||
problem referring to Range and Cells | Excel Programming | |||
Selecting a range without referring to specific cells | Excel Programming | |||
Referring to a user-selected range | Excel Programming |