A VBA Macro that doesn't know when to stop.. :)

[Cumulous]

Jean-Guy

Shame on me, I had not picked up on the requirement for the space
after >, which makes a nasty requirement completely fiendish.

I applaud your solution. It's not easy to understand but works like a
charm.

- Bruce

It does indeed. And thank you, Bruce, for your help as well. I made
the change you suggested in JGM's code (regarding the Integer/Long
declaration). I'm sorry your post got lost in the shuffle!

As I said earlier, I'm shocked that such a small request was such a
large nightmare! I'm almost afraid to post again.




Cumulous

 

[Jonathan West]

As I said earlier, I'm shocked that such a small request was such a
large nightmare! I'm almost afraid to post again.

Don't worry about that. One of the benefits to those of us who answer
questions is that we learn new techniques and ideas from time to time as a
result of answering questions. Feel free to post again any time.

 

[JGM]

Took the words right out of my mouth!

 

[JGM]

Don't worry about it... I know it may seem strange to some... but I like
doing this kind of stuff... It's like a giant puzzle!

Have a good one!