🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac.apps
Article #7377

excel question

#7377
From: Alan Ramaley
Date: Sat, 02 Feb 1991 04:56
13 lines
829 bytes
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
Technical Details
Message-ID: <17557@csli.Stanford.EDU>
Path: arc1-ca.pugleaf.net!utzoo!attcan!uunet!olivea!decwrl!shelby!csli!ramaley

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!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