View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default loop replacement of multiple if-then's

The simple answer is (pick one)
- you aren't looping properly
- your logic is flawed
- your code is bad
- your workbook is poorly structured and the code doesn't interact with it
properly

But we can't test your code because you didn't explain the structure of the
workbook that it is working on, or any of its parameter. So we can't tell
you _why_ it's bad until you simply tell us what you want to do.

Bernie


"dsi" wrote in message
ups.com...
I was trying to simpify my question.
Basically I want to know:

1 - Why the MsgBox's stop working (even the ones before the infinite
loop).

2 - Why the do while...loop doesn't "drop in" to replace the 4 if then
statements.