change increasment in a for loop
 

i have a "for" loop while creating a macro
how do i change increasment by 3 and not 1

example:
for i = 3 to 27
If isempty(j,i) Then next i

I need i to increase by 3 not 1

Thanks

change increasment in a for loop
 

for i = 3 to 27 step 3

Jared wrote:

i have a "for" loop while creating a macro
how do i change increasment by 3 and not 1

example:
for i = 3 to 27
If isempty(j,i) Then next i

I need i to increase by 3 not 1

Thanks

--

Dave Peterson

change increasment in a for loop
 

for i = 3 to 27 step 3

Regards

Trevor


"Jared" wrote in message
...
i have a "for" loop while creating a macro
how do i change increasment by 3 and not 1

example:
for i = 3 to 27
If isempty(j,i) Then next i

I need i to increase by 3 not 1

Thanks

change increasment in a for loop
 

Thanks,
Jared

"Trevor Shuttleworth" wrote:

for i = 3 to 27 step 3

Regards

Trevor


"Jared" wrote in message
...
i have a "for" loop while creating a macro
how do i change increasment by 3 and not 1

example:
for i = 3 to 27
If isempty(j,i) Then next i

I need i to increase by 3 not 1

Thanks