| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping Find from wrapping around in code?
I'm using Find to loop through column ET on my sheet and find all the
"2"s. I stop the search when the .Row of the last .FindNext is past the last row of the sheet. But it never is. That's because when it actually does find the last one, the next .FindNext wraps back to the top of the column again! Is there some way to stop it? The Help doesn't seem to suggest a solution. Maury |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| stopping code | Excel Discussion (Misc queries) | |||
| VBA code stopping in odd places | Setting up and Configuration of Excel | |||
| Stopping errors when a find statement doesn't find! | Excel Programming | |||
| Stopping Code | Excel Programming | |||
| stopping code from looping | Excel Worksheet Functions | |||
![Maury Markowitz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
