Looping a VBA code but missing a number

**jshaw82** · 10-24-2014, 07:48 AM

I'm trying to loop the following code

Please Login or Register  to view this content.

What I actually want it to do is loop 2 to 8 and 10 and 11 so to miss out 9. Can anyone help

Thanks in advance

John

**ChrisVBA** · 10-24-2014, 07:53 AM

Here you go:

Please Login or Register  to view this content.

For explanation: I just added an If statement around your code within the iTemp loop that prevents your loop code from being executed in case of the iTemp variable being 9.

**jshaw82** · 10-24-2014, 09:19 AM

thanks a lot

Looping a VBA code but missing a number

LinkBack

Thread Tools

Rate This Thread

Display

Looping a VBA code but missing a number

Re: Looping a VBA code but missing a number

Re: Looping a VBA code but missing a number

Thread Information

Users Browsing this Thread

Similar Threads

Code Help Looping N number of lines

[SOLVED] Find missing number and copy only missing number to another coloumn

[Solved] Looping Thru Worksheets. What am I missing?

[SOLVED] Vb code To Find the missing triplets and complete the number series..?

Code to Return Missing Number In Range

Bookmarks

Bookmarks

Posting Permissions