Thread: change increasment in a for loop
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote