PDA

View Full Version : [SOLVED:] Find Method Question



MWE
08-03-2005, 09:03 AM
The VBA Find method starts searching for "what", after some specified cell in a range. If you do not specifiy the "after" parameter, find assumes it to be the first cell in the range; thus Cells(2) is the first cell examined if you set the after parameter to Cells(1) or let it default. How can I force the find method to start at the first cell and search to the last?

One approach is to start the search "after" the last cell in the range. That works, but seems like a bandaid.

Thanks

Zack Barresse
08-03-2005, 09:12 AM
One approach is to start the search "after" the last cell in the range. That works, but seems like a bandaid.
Yes. And yes.

MWE
08-04-2005, 06:46 AM
Yes. And yes.
Thanks (I guess). I wonder why the Find method does not have exclusive variables "StartAt" and "StartAfter" { or would allow you to use Cells(0) to indicate a starting point of Cells(1) } The bandaid is not hard to implement, but does require you to determine the last cell in the range