Path: 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

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