$$Excel-Macros$$ Re: Select Case Question

2009-10-30 Thread larry
Thanks. My apologies for the duplicate postings. I didn't realize that hitting tab or some other combination opened an new post screen. The loop is one big counter. On Oct 29, 10:53 am, Paul Schreiner wrote: > No, because VBA executes "linearly". > meaning that if the command: Select Case A-B >

$$Excel-Macros$$ Re: Select Case Question

2009-10-29 Thread Paul Schreiner
No, because VBA executes "linearly". meaning that if the command: Select Case A-B is valid at the time it executes, then changes made afterward do not affect previous statements. (be sure you put some kind of loop counter on you Do..Loop to make sure that it doesn't get stuck in an infinite loop..