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

Row(A10), Column(A10) - same thing, isn't it? Do you want the value of A10,
do you want the value of row10+5 and Column A+5, i.e. Row 15 and Column F, or
then F15, or do you want to add 5 to the value of A10
--
Hth

Kassie Kasselman


"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