For Next Statement with If Statement Reducing Upper Variable

Hi,

Hope you can help, below I am trying to run through each sheet in an activeworkbook and perform code. Some of the code will delete an activesheet if it meets the requirements. I have assigned the upper variable as SheetsCount, this can be reduced by a sheet being deleted in the code, however my code below keeps running passed the redefined upper limit variable SheetsCount. So after a sheet is deleted and SheetsCount is redefined as -1 its orginal value the code keeps running passed the new value of SheetsCount.

I'm obviously missing something basic, and Ideas?

Please Login or Register  to view this content.

Sorry I might not have explained this very well, but have given a basic example of my error in the code above.

Any input / ideas welcomed!

This will do what you want.

Please Login or Register  to view this content.

When the sheet is deleted, excel would place us on the next sheet which would actually be n + 1 in this situation, so I reset it at this stage. I'll have a look if this logic flows a bit more!

Just looking at the code (it may change the sheet that is active) but your code decrements what you are counting to (correct) but then it decrements the counting variable n (which is wrong). The program changes active sheet but does not automatically update your n to n+1.

Thanks for all the info and help.

I followed your input and looped backwards and this has resolved my issue.

Great advice and info from all, thanks.