Path: utzoo!attcan!uunet!olivea!decwrl!shelby!csli!ramaley
From: ramaley@csli.Stanford.EDU (Alan Ramaley)
Newsgroups: comp.sys.mac.apps
Subject: excel question
Message-ID: <17557@csli.Stanford.EDU>
Date: 2 Feb 91 04:56:25 GMT
Organization: Center for the Study of Language and Information, Stanford U.
Lines: 13

Excel, in a macro, always follows a reference.  so if cell c2 in a macro
sheet has a reference, say, 'partition'!$c3, or something along those
lines, doing a select(c2) won't select cell c3 on partition, but instead
will follow the reference, and try to select the region described by cell
c3.

Normally this is a good thing; but how do you stop this dereferencing?
Otherwise, "input(8)" which returns a reference, is useless, if you want
to do an operation on the cells selected.


-- 
--Alan