Re: Excel question

Article View: comp.sys.mac

Article #45909

#45909

From: ccc_ldo
Date: Fri, 09 Feb 1990 08:23

8 lines
684 bytes

Try using the "indirect" function. For example

	indirect("r" & row_no & "c" & col_no, false)

where row_no is an integer row number and col_no an integer column
number, will return the value of the cell at that position. The
second argument is false to indicate R1C1-style references (more
easily synthesised than A1-style references).

Technical Details

Message-ID: <106.25d2f4fd@waikato.ac.nz>

Path:

arc1-ca.pugleaf.net!utzoo!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!samsung!munnari.oz.au!kaukau.comp.vuw.ac.nz!virtue!ccc_ldo

References: <1990Feb7.152454.22161@cadre.dsl.pitt.edu>

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!utzoo!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!samsung!munnari.oz.au!kaukau.comp.vuw.ac.nz!virtue!ccc_ldo
From: ccc_ldo@waikato.ac.nz
Newsgroups: comp.sys.mac
Subject: Re: Excel question
Message-ID: <106.25d2f4fd@waikato.ac.nz>
Date: 9 Feb 90 08:23:13 GMT
References: <1990Feb7.152454.22161@cadre.dsl.pitt.edu>
Lines: 8

Reply to Parent Message