View Single Post
  #4   Report Post  
Mark Mulik
 
Posts: n/a
Default

Howdy.

I don't really understand how the Indirect function works, but this
did the trick. Excel's help file on Indirect is not very helpful.

Many thanks for the suggestions. I tried the other two that were
posted here, but they didn't have the desired results. This one below
did what I wanted.

"N Harkawat" wrote in message ...
=INDIRECT("Sheet1!"&"D"&(B4+4))


Thanks.
Mark