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
 

Thanks,
wonderful

"Dave Peterson" wrote:

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