Excel macro "loop"

[Leon Obers]

To avoid several hand mader starts (400 x) of a macro I want to edit the
VSB macro in a loop. I am not familiar with VSB but do have some
experiance with other database languages.
What is the exact way / commands to write down (edit) the macro?

Someting like this.

---------------------------------------------------------------
Start loop
if n < 401
n = n+1
{a macro workaround with move, copy and past}
endif
end loop

 

[raypayette]

The code is:
Do While n < 401
n = n + 1
'{a macro workaround with move, copy and past}
Loop

You might also have:
Do
n = n + 1
'{a macro workaround with move, copy and past}
Loop While n < 40

 

[NickHK]

Leon,
You mean something like :

Dim i as long
For i=1 to 400
call YourMacro
next

NickHK

 

[Leon Obers]

Leon,
You mean something like :

Dim i as long
For i=1 to 400
call YourMacro
next

Great, works as a train.
Thank you very much for this sollution.