-
November 12th, 2004, 21:08 PM
#1
Excel programming > Need Help !!!
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
-
November 22nd, 2004, 18:39 PM
#2
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Bookmarks