Thread: OFFSET and INDIRECT
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default OFFSET and INDIRECT
In which case =OFFSET(INDIRECT("Sheet1!"&$F$1),,ROWS($1:1)-1)
--
David Biddulph

"AirgasRob" wrote in message
...
Is it possible to use INDIRECT in a OFFSET formula?

Here is the formula =OFFSET(Sheet1!$B$29,,ROWS($1:1)-1)

I would like to replace $B$29 with =INDIRECT($F$1)


Reply With QuoteReply With Quote