Article View: comp.sys.mac.apps
Article #3214help with Excel macro!
From: Martin NMN Thurn
Date: Wed, 13 Jun 1990 14:54
Date: Wed, 13 Jun 1990 14:54
16 lines
1315 bytes
1315 bytes
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!"
Technical Details
Message-ID:
<24904@unix.cis.pitt.edu>Path:
arc1-ca.pugleaf.net!utzoo!attcan!uunet!cs.utexas.edu!samsung!usc!rutgers!netnews.upenn.edu!dsinc!unix.cis.pitt.edu!er225711Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!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