Article View: comp.sys.mac
Article #23467Re: Excel problem...
From: Brian Matthews
Date: Sun, 10 Jan 1988 00:36
Date: Sun, 10 Jan 1988 00:36
30 lines
1833 bytes
1833 bytes
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
Technical Details
Message-ID:
<2320@cxsea.UUCP>Path:
arc1-ca.pugleaf.net!utzoo!utgpu!water!watmath!clyde!rutgers!mit-eddie!uw-beaver!ssc-vax!cxsea!blmReferences:
<2318@cxsea.UUCP> <6091@cisunx.UUCP>Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!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