View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Graham H Graham H is offline
external usenet poster
 
Posts: 56
Default Indirect Alternatives

I have large numbers of cells which contain a formula as below

=IF(ISERROR(INDIRECT("'" & A2 & "'!C41")),0,INDIRECT("'" & A2 & "'!C41"))

This does exactly what it is supposed to but it definately creates a slower calculation
process when set on automatic calculation which really needs to be on. I checked using
Fastexcel and the block is creating a bottleneck. Is there another alternative to this
which would produce the same result but faster? I would welcome any guidance.

Graham