🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac
Article #23439

Re: Excel problem...

#23439
From: Larry D Adams
Date: Fri, 08 Jan 1988 18:50
27 lines
1496 bytes
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.  Of course, by inserting the "!" before the "R"
will give an error.  Again, I don't know why.  But, the line above will
make the current cell the active cell on the active worksheet.  Any
explanations or questions, please e-mail me.

	larry adams
	u of pgh
	adams3
Technical Details
Message-ID: <6091@cisunx.UUCP>
Path: arc1-ca.pugleaf.net!utzoo!utgpu!water!watmath!clyde!rutgers!mit-eddie!uw-beaver!cornell!rochester!PT.CS.CMU.EDU!cadre!pitt!cisunx!adams3
References: <2318@cxsea.UUCP>

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!utgpu!water!watmath!clyde!rutgers!mit-eddie!uw-beaver!cornell!rochester!PT.CS.CMU.EDU!cadre!pitt!cisunx!adams3
From: adams3@cisunx.UUCP (Larry D Adams)
Newsgroups: comp.sys.mac
Subject: Re: Excel problem...
Message-ID: <6091@cisunx.UUCP>
Date: 8 Jan 88 18:50:12 GMT
References: <2318@cxsea.UUCP>
Reply-To: adams3@unix.cis.pittsburgh.edu.UUCP (Larry D Adams)
Organization: Univ. of Pittsburgh, Comp & Info Sys
Lines: 27