View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jared Jared is offline
external usenet poster
 
Posts: 109
Default change increasment in a "for" loop

Great,
Thanks

"JLatham" wrote:

use the Step option of the For statement:

For i = 3 To 27 Step 3

negative numbers are also allowed as
For i = 27 to 3 Step -3

"Jared" wrote:

I have a loop function
For i = 3 To 27
If isempty(i,j) then next i


How do i make i increase by 3?