Brad;602306 Wrote:
I have Excel 2002 and routinely use the macro recorder. I can read the
macros and make simple edits, but never learned to program in VB and
my
fortran programming experience is from 30 years ago. After recording
a
macro, I want it to loop 15 times before exiting. What lines to I need
to
add to the code to start and end the loop? I already have the macro.
It
basically inserts a line, totals certain columns and formats one cell.

Brad

Code:
--------------------
For i = 1 to 15
'your repeating code here (or a call to your macro)
Next i
--------------------

You can use i within your code, so the first line could be say:
For i = 16 to 30
or
For i = 10 to 50 step 3
or
For i = 20 to 5 step -1
etc. etc.
There are other loops:

Code:
--------------------
Do
'... your code including altering value of j here
loop until j 23
--------------------


or

Code:
--------------------
Do while j <15
'... your code including altering value of j here
Loop
--------------------


press f1 when your text cursor is sitting on the word 'do' in the vb
editor (or on the word 'for').


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: 558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=166946

Microsoft Office Help