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

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