Hi All
One question, how do I Find a value in A:A99999999 and select the cell if the value are found?
I have tried this without any luck
Worksheets("sheet1").Column(1).Find(What:=TextBox3, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False).Select
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by Vibov; 05-19-2022 at 04:30 AM.
The obvious issue is the typo ...The rest of the statement looks fine.Please Login or Register to view this content.
However, that will throw an error if the search term is not found. Consider assigning the results of the search to a range and then checking that range is not nothing....
Please Login or Register to view this content.
Last edited by cytop; 05-19-2022 at 03:27 AM.
Hi Cytop
Thanks but it comes with an "run-time error 1004 - Select method of range class failed?
It'll also throw an error if Sheet1 is not active and the Find succeeds ...
Do as I said - assign the results of the search to a Range variable.
If the range is not nothing after the search then ensure the range Parent sheet is active before selecting the range
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks