Excel macro "loop"

L

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
 
R

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
 
N

NickHK

Leon,
You mean something like :

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

NickHK
 
L

Leon Obers

NickHK said:
Leon,
You mean something like :

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

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