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
One approach is to start the search "after" the last cell in the range. That works, but seems like a bandaid.
Thanks