Excel Macro Search Debug Error

[Legacy 185509]

I am using a button and using search to search for term "Resize to show all values" currently it is searching for term and selecting it, but if it is not found it shows me debug error
please help me fix this error, if result is not found I want it do nothing may be if result is not found select cell A1 or something like that here is my code

Private Sub CommandButton2_Click()
Range("C1").Select
Cells.Find(What:="resize to show all values", After:=ActiveCell, LookIn:= _
        xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext _
        , MatchCase:=False, SearchFormat:=False).Activate

End Sub

 

[Legacy 185509]

I am sorry it worked, I forgot that my column A wasn't freeze anymore

I am total n00b at VBA

 

[sous2817]

No problem at all...give this a whirl:

Sub test()
Dim foundCell As Range

Set foundCell = Cells.Find(What:="resize to show all values", After:=ActiveCell, LookIn:= _
        xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext _
        , MatchCase:=False, SearchFormat:=False)

If Not foundCell Is Nothing Then
    foundCell.Activate
Else:
    Range("A19").Activate
End If
End Sub

 

[Legacy 185509]

that works well too, sorry I know I am asking too much... but I am working with huge database, in which I can read data like 1/100000 of the second so imagine how much data is there even A65536 is not enough.. I was wondering if not found it would try to search next and even not found go to 0 or something. go to 0 works better for me because I have column A freeze.
thanx again

 

[CharlesChuckieCharles]

Do you understand what on Error GOTO 0 means?

<TABLE><TBODY><TR><TD>On Error GoTo 0</TD><TD>Disables any enabled error handler in the current procedure.</TD></TR></TBODY></TABLE>

it doesn't send you anywhere of the sheet

 

[Legacy 185509]

ok oky that makes sense, I don't know why I said it goes on top of the sheet, may be it does go on top of the sheet after what I am doing to it.

 

[sous2817]

Sorry, re-reading my post wasn't clear. I should have said (as CharlesChuckieCharles pointed out) that:

For what it's worth, mine doesn't go to 0 (which you're interpreting as a spreadsheet location) it turns error checking back on.

Either way, do you now have an acceptable solution or is there something else you need? I'm not sure what you mean by "...I was wondering if not found it would try to search next and even not found go to 0 or something. go to 0 works better for me because I have column A freeze."

 

[Legacy 185509]

sorry nevermind, I was over thinking...

 

[Legacy 185509]

thanx alot guys for help

 

[sous2817]

HURRAY!! Glad everything is sorted out. Best of luck with the rest of your project.

 

[Legacy 185509]

lol thanx one more idea, I came up with, some where in this project I am using auto clicker, so and that auto clicker is clicking this marco/vba code button, since I cannot program the auto clicker, I can program the excel auto clicker right, may be with help from you guys.

ok here is what I thought,
if result is not found can I have excel press "Ctrl+10" to stop the auto clicker from keep on clicking on search button.

please help me know if you understand my question
Thank you once again