If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem with indirect from cell on external worksheet
I am having a problem indirectly addressing a cell on a
second worksheet (that is open). I found this article and when I tried the example it did now work similarly. http://support.microsoft.com/?kbid=151323 When I simplified the example to indirect(a2) where a2 was '[book1.xls]sheet1'!a1 it also failed. Thanks for your help. |
#2
|
|||
|
|||
Problem with indirect from cell on external worksheet
" wrote...
I am having a problem indirectly addressing a cell on a second worksheet (that is open). I found this article and when I tried the example it did now work similarly. http://support.microsoft.com/?kbid=151323 When I simplified the example to indirect(a2) where a2 was '[book1.xls]sheet1'!a1 it also failed. How did it 'fail'? Did it return #REF!, some other value that wan't equal to that of '[book1.xls]sheet1'!A1, Excel wouldn't allow the formula to be entered, what? -- Never attach files. Snip unnecessary quoted text. Never multipost (though crossposting is usually OK). Don't change subject lines because it corrupts Google newsgroup archives. |
#3
|
|||
|
|||
Problem with indirect from cell on external worksheet
I'm sorry - it failed with a #ref in the function. The
example as I understand it should have resulted in "This is a test" in In Book2, Sheet1, cell B1 |
#4
|
|||
|
|||
Problem with indirect from cell on external worksheet
Works for me.. What failed, do you get a #REF error?
I named a workbook book1.xls, copied your example from your post and it worked.. -- Regards, Peo Sjoblom wrote in message ... I am having a problem indirectly addressing a cell on a second worksheet (that is open). I found this article and when I tried the example it did now work similarly. http://support.microsoft.com/?kbid=151323 When I simplified the example to indirect(a2) where a2 was '[book1.xls]sheet1'!a1 it also failed. Thanks for your help. |
#5
|
|||
|
|||
Problem with indirect from cell on external worksheet
" wrote...
I'm sorry - it failed with a #ref in the function. The example as I understand it should have resulted in "This is a test" in In Book2, Sheet1, cell B1 I'm going to guess that Book2 hasn't been saved, so it doesn't have a file extention. Try entering [book2]Sheet1!B1 in cell A2 of the active worksheet in the active workbook. Then try =INDIRECT(A2) -- Never attach files. Snip unnecessary quoted text. Never multipost (though crossposting is usually OK). Don't change subject lines because it corrupts Google newsgroup archives. |
Thread Tools | |
Display Modes | |
|
|