Path: utzoo!attcan!uunet!cs.utexas.edu!samsung!usc!rutgers!netnews.upenn.edu!dsinc!unix.cis.pitt.edu!er225711
From: er225711@unix.cis.pitt.edu (Martin NMN Thurn)
Newsgroups: comp.sys.mac.apps
Subject: help with Excel macro!
Keywords: excel,macro,HELP!
Message-ID: <24904@unix.cis.pitt.edu>
Date: 13 Jun 90 14:54:38 GMT
Reply-To: thurn@lcl.cmu.edu (Martin NMN Thurn)
Followup-To: comp.sys.mac.apps
Organization: Computer-Accelerated Language Learning -- Understanding Written Japanese project, Pittsburgh PA
Lines: 15

I need help with (what I thought was going to be) a simple Excel macro.
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,
just so I can put my data _somewhere_!)  In other words, given (e.g.)
=FOR("mycounter", 4, 18, 1)
how can I use the value of "mycounter" in an "R1C1"-type expression within 
the loop?  
The manuals don't say jack s*** about loop variables (why give them a 
name if you can't reference their value?), and there's NOT ONE WORD 
about the macro debugger.  
Thanks in advance to anyone who can help me with this.
-- 
---Martin Thurn          thurn@lcl.cmu.edu

"Wow!  Someone at CMU who doesn't have a bunch of
  numbers and plus signs in their name!"