Path: utzoo!attcan!uunet!clyde.concordia.ca!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!pt.cs.cmu.edu!dsl.pitt.edu!dsl.pitt.edu!geb
From: geb@dsl.pitt.edu (Gordon E. Banks)
Newsgroups: comp.sys.mac
Subject: Excel question
Message-ID: <1990Feb7.152454.22161@cadre.dsl.pitt.edu>
Date: 7 Feb 90 15:24:54 GMT
Sender: news@cadre.dsl.pitt.edu (Usenet News System)
Organization: Decision Systems Laboratory, Univ. of Pittsburgh, PA.
Lines: 10


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.