Thread: Indirect function result in #REF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Indirect function result in #REF
Try it as: =INDIRECT("A3")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Julie L" wrote:
Hi,

I tried to use the indirect function (i.e. indirect(A3)) where A3 contains a
number (say 3), but the result came back as #REF. Any idea what caused the
problem.

Thanks,
Jules
Reply With QuoteReply With Quote