Looping

[Icewizz]

Hi,

I'm getting a little bit more familiar with Lotus 1-2-3 Macros but I just hit a brick wall. I want to make a macro that look each line of my data, one by one but...

To do this I created Ranges and I want the range path to change and go down 1 each time it goes inside my FOR.

Exemple:

{FOR Report:G5;1;2000;1;PREPARING}

Preparing {IF PbsproDataNext = ""}{BRANCH NoMore}
{EDIT-GOTO pbsprodata}
{IF (Report:$A$8+Report:G5=Report:$A$9+Report:G5)}{BRANCH Same}
{BRANCH NotSame}

Same/NotSame: (Here I want to make my selected range go down the same number of rows that my Counter for my FOR (that is: Report:G5)

Is that possible.
If yes how ?????

Thanks,

Icewizz

 

[Icewizz]

PS : this is one of my Ranges and they are all build the same.

{RANGE-NAME-CREATE PbsproData;Report:$A9..Report:$f9}

Thanks,

Icewizz

 

[garrym01]

You can create and change pointer addresses using individual cells, and catenating the contents to form references in commands.

if cell H5 has the letter B and cell I5 the value 7, the the following macro will place the pointer in cell B7

{GOTO}
+H5&@string(I5)
~
I think you can see how you can easily create all sorts of cell references.