change increasment in a for loop

J

Jared

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
 
D

Dave Peterson

for i = 3 to 27 step 3
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
Click to expand...
 
Top