View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Harlan Grove
 
Posts: n/a
Default OFFSET() question for '97

"Adam Kroger @hotmail.com" wrote...
In the OFFSET() function, is there something that you can put ub the
formula for "reference" that returns as the cell when you do not know what
the cell address will be?

FURTHER EXPLANATION:
OFFSET(reference,rows, cols,height,width)

OFFSET(this.cell,0,5)

....

If by this.cell you mean a reference to the cell containing the formula,
then don't use OFFSET. Use INDIRECT with R1C1 addressing.

INDIRECT("RC[5]",0)