I have some code which brings up the find/replace box but it brings up the replace rather than the find. Is there a way to bring up the find tab?
Hereis the code
Sub TTC_Find() ' ' TTC_Find Macro Application.ScreenUpdating = True Application.CommandBars.FindControl(ID:=313).Execute ' End Sub
Also, I have an anomoly regarding the find. Sometimes it scrolls down to the row using the above code but other times the found result is in the information box but it doesn't scroll to that row. Any ideas?