Home |
Search |
Today's Posts |
#1
Posted to comp.lang.basic.visual.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Excel macro "loop"
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 --------------------------------------------------------------- -- Vr.groet - regards, Léon Obers |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Excel macro "loop"
Leon,
You mean something like : Dim i as long For i=1 to 400 call YourMacro next NickHK "Leon Obers" wrote in message ... 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 --------------------------------------------------------------- -- Vr.groet - regards, Léon Obers |
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Excel macro "loop"
NickHK wrote: 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. -- Vr.groet - regards, Léon Obers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
LOOP BETWEEN "FRONT" AND "END" SHEETS? | Excel Programming | |||
Sending macro based e-mail with built-in "Heading" and "Text" | Excel Programming | |||
Problem with "For each" loop using .NET Interop and Excel | Excel Programming |