Thread: Can you use INDIRECT in 3-D references?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gdcprogrc Gdcprogrc is offline
external usenet poster
  
Posts: 5
Default Can you use INDIRECT in 3-D references?
For example
=SUM(INDIRECT(C10))
where C10 would contain
="Sheet2:"&"Sheet3!"&"A"&ROW()
always returns #REF!.
However, ="Sheet3!"&"A"&ROW() as the Cell C10 entry will work fine.
Reply With QuoteReply With Quote