View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default 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