Gates Is Antichrist
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 1,961
Which is it? XL2002 Help is contradictory. They test a .Findnext loop against Nothing; yet they say (as we all know) that it DOES wrap around.
Is what really happens that you get "one Nothing per wraparound?"
Note: I have been able to force a Nothing, and you can too, using what I perceive as an XL2002 bug:
merge b2 to c3. Type FOO in B2.
put cursor on a1
Ctrl-F
Type FOO
Hit enter twice.
Merged cells and finds are certainly a nightmare. Anyway, is there any other way that you can get Nothing on findnext?
(Well, I can think of another - moving off the active sheet, or selecting an unmatching range, and going shift-F4! Is their test against nothing simply to address things like that?)
Is what really happens that you get "one Nothing per wraparound?"
Note: I have been able to force a Nothing, and you can too, using what I perceive as an XL2002 bug:
merge b2 to c3. Type FOO in B2.
put cursor on a1
Ctrl-F
Type FOO
Hit enter twice.
Merged cells and finds are certainly a nightmare. Anyway, is there any other way that you can get Nothing on findnext?
(Well, I can think of another - moving off the active sheet, or selecting an unmatching range, and going shift-F4! Is their test against nothing simply to address things like that?)