View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default For Next (non consecutive values for i)

for i = 1 to 10

Select Case i
case 1, 4, 5, 6, 8, 10

End Select

Next

--
Regards,
Tom Ogilvy

"caroline" wrote:

When using the For i = 1 to 10
€˜Your code
Next i

Can I define i = 1 to 10 (excluding certain values)?
I want the code to be executed only for i= 1,4,5,6,8,10

Thanks
--
caroline