Thread: OFFSET() function with external references
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
braultg braultg is offline
external usenet poster
  
Posts: 3
Default OFFSET() function with external references
You should have read :

"Workbook2.xls" contains (with other source opened)
A1 : =OFFSET([Workbook1.xls]Sheet1!A1; 0; 1)

= Return "ROGER" when workbook1.xls is open
= Return #VALUE otherwise

Reply With QuoteReply With Quote