Hi all,
is there a way to use the for next statement and exclude some numbers.
For example
for i = 1 to 18 (and) 25 to 30 (and) 40 to 73.
.
.
.
.
next i
That it runs from 1 to 73, but skip the 19to24 and 31to39.
Thx, jan
Hi all,
is there a way to use the for next statement and exclude some numbers.
For example
for i = 1 to 18 (and) 25 to 30 (and) 40 to 73.
.
.
.
.
next i
That it runs from 1 to 73, but skip the 19to24 and 31to39.
Thx, jan
Try this
![]()
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
You can "cheat"
![]()
Please Login or Register to view this content.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
thank you, it works pretty good...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks