View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default cell contents from a reference

Hi,

Try:

=INDIRECT(ADDRESS(ROW(A15),COLUMN(F1)))

HTH
Jean-Guy

"NimbleThunder" wrote:

how do I get the value stored in a cell from a reference to the cell.

Example: I want to get the value stored in:
Address(ROW(A10)+5,COLUMN(A10)+5)

what function do I use to get the value?


--
Thanks for the help,

Denis Nothern
Savvis Communications