Path: utzoo!censor!geac!torsqnt!news-server.csri.toronto.edu!cs.utexas.edu!samsung!zaphod.mps.ohio-state.edu!usc!apple!agate!shelby!csli!ramaley
From: ramaley@csli.Stanford.EDU (Alan Ramaley)
Newsgroups: comp.sys.mac.apps
Subject: going from (1,1) to "R1C1" (excel)
Message-ID: <16702@csli.Stanford.EDU>
Date: 4 Dec 90 20:17:45 GMT
Organization: Center for the Study of Language and Information, Stanford U.
Lines: 16

Hey folks.  I'm writing an excel macro to partition a mailing list into
manageable chunks of addresses.

What I can't figure out is how to take a macro name (as defined by
SET.NAME), and turn it into a cell reference.  I want to go to each
row, look if it has a certain characteristic, and then copy it to
another file.  You can do the first part with INDEX(), but the second
needs to be done with SELECT(), and SELECT() needs a cell reference.
I want the cell reference corresponding to row "yrow", columns 1
through 4.

How can I do it?  And if you know, is there a "Inside Mac DA" style
reference to Excel's macros?
							--Alan