[comp.sys.mac] Excel question

geb@dsl.pitt.edu (Gordon E. Banks) (02/07/90)

I have a question on Excel.  Is there a handy way of converting a
number (entered in data) into a reference?  Like a function,
say fun(20) which would return A20.  I can see perhaps how to
use a macro with the macro function offset to do it, but there
must be some easier way than that.  The application asks for a line number to 
be entered
from another worksheet and then I want to copy data from
that line.  There is no clean way to search the other worksheet
for the proper data without having a human look at it.

ccc_ldo@waikato.ac.nz (02/09/90)

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).