Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Its wraparound nature suggests it would never return Nothing (assuming
that .Find itself didn't return nothing). Besides, the XL03 FindNext Method help instructs you to test its returned address. So why check for Nothing? Moreover, why does their help show this? Do c.Value = 5 Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address < firstAddress Why test if c is Nothing *AND* do the c.address wraparound test? Is there an occasion where the wraparound doesn't happen? (I could see this perhaps only if .Find failed; but that's not the case in the help text.) In testing I can never get FindNEXT to return Nothing. Only FIND. Separate question: the "After" argument help text in XL03 says "If this argument isn’t specified, the search starts after the cell in the upper-left corner of the range." Am I high, or shouldn't that say, "starts after the active cell" ?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Findnext | Excel Discussion (Misc queries) | |||
Using 'Find' and 'FindNext' in vba | Excel Programming | |||
FindNext | Excel Programming | |||
FindNext | Excel Programming | |||
problem with .FindNext | Excel Programming |