im not to sure if im in the right part of the forum to submit this post but here goes.. ok im trying to program somthing in excell. ive make a search button in excell i need it to seach all text in the spread sheet. i cant make it work.please help
Printable View
im not to sure if im in the right part of the forum to submit this post but here goes.. ok im trying to program somthing in excell. ive make a search button in excell i need it to seach all text in the spread sheet. i cant make it work.please help
VBA : (U type which value that U want to search on Cell("A1"). Then it will search whole document.
Sub Macro1()
Range("A1").Select
Cells.Find(What:=ActiveCell.Value, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, MatchByte:=False, SearchFormat:=False).Activate
End Sub
Hope it can help u.