Article View: comp.sys.mac.apps
Article #3273Re: help with Excel macro!
From: Douglas Strauss
Date: Mon, 02 Jul 1990 03:23
Date: Mon, 02 Jul 1990 03:23
20 lines
1179 bytes
1179 bytes
In article <669@motbos.UUCP> artp@motbos.UUCP (Art Parmet) writes:
>In article <24904@unix.cis.pitt.edu>, er225711@unix.cis.pitt.edu (Martin NMN Thurn) writes:
>> The part that doesn't work is: I have a =FOR loop, and I want to use the
>> counter variable to reference rows/columns of a worksheet (active or macro,
>
>The solution to your problem is a feature of Excel called "Text Concatenation".
>(PS: The hot line support from Microsoft is responsive, courteous and quite
>knowledgable !!!)
>
>=SELECT("R["&My_Counter&"]C[0]")
Or you may want to use the Offset macro command. Although it is in A1
notation but much easier to read.
=SET.NAME("My_Counter",1)
=SELECT(OFFSET(ACTIVE.CELL(),My_Counter,0))
Doug
P.S. Thanks for the PS:!!!
Technical Details
Message-ID:
<55573@microsoft.UUCP>Path:
arc1-ca.pugleaf.net!utzoo!attcan!uunet!microsoft!dougstReferences:
<24904@unix.cis.pitt.edu> <669@motbos.UUCP>Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!attcan!uunet!microsoft!dougst From: dougst@microsoft.UUCP (Douglas Strauss) Newsgroups: comp.sys.mac.apps Subject: Re: help with Excel macro! Keywords: excel,macro,HELP! Message-ID: <55573@microsoft.UUCP> Date: 2 Jul 90 03:23:34 GMT References: <24904@unix.cis.pitt.edu> <669@motbos.UUCP> Reply-To: dougst@microsoft.UUCP (Douglas Strauss) Organization: Microsoft Corp., Redmond WA Lines: 20