Thread: cell contents from a reference
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default cell contents from a reference
=INDIRECT(ADDRESS(ROW(A10),COLUMN(A5)+5))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email on the web site)

"NimbleThunder" wrote in message
...
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



Reply With QuoteReply With Quote