Path: utzoo!utgpu!water!watmath!clyde!rutgers!mit-eddie!uw-beaver!ssc-vax!cxsea!blm
From: blm@cxsea.UUCP (Brian Matthews)
Newsgroups: comp.sys.mac
Subject: Re: Excel problem...
Message-ID: <2320@cxsea.UUCP>
Date: 10 Jan 88 00:36:05 GMT
References: <2318@cxsea.UUCP> <6091@cisunx.UUCP>
Reply-To: blm@cxsea.UUCP (Brian Matthews)
Organization: Computer X Inc.
Lines: 30

Larry D Adams (adams3@unix.cis.pittsburgh.edu.UUCP) writes:
|In article <2318@cxsea.UUCP> blm@cxsea.UUCP (Brian Matthews) writes:
|>I'm using Excel 1.05 on a MacPlus with the latest system, and am
|>experiencing a problem.  I have a macro sheet, and around R100C1, the
|>following:
|>
|>=SELECT(!RC)
|>=RETURN()
|>When I select another worksheet, and run this macro, it selects
|>R100C1, which is the current cell in the macro sheet, instead of
|>selecting the current cell in the worksheet (in other words, not
|>moving the active cell).
|I'm not exactly sure why this isn't working.  Yes, it seems to me also
|that this *should* work.  However, it seems easily overcome.  Take a
|look at why you want to do this.  Do you just want to make the current
|cell the active one?  Easy.  Just type
|	=SELECT(,"RC")
|that'll do it for you.

The example I gave was a simplified version of what I was actually trying to
do.  The work around I used was to use text like you suggest.  I can't remember
why right now, but using text was a lot messier (although it had the advantage
of working :-)), so I tried the =SELECT(!RC) form, and it annoyed me that it
didn't work and should have.  Thanx for the info.

-- 
Brian L. Matthews                               "A power tool is not a toy.
...{mnetor,uw-beaver!ssc-vax}!cxsea!blm          Unix is a power tool."
+1 206 251 6811
Computer X Inc. - a division of Motorola New Enterprises