Results 1 to 2 of 2

Thread: Excel programming > Need Help !!!

  1. #1
    Junior Member
    Join Date
    Oct 2004
    Posts
    3

    Question 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

  2. #2
    Junior Member
    Join Date
    Nov 2004
    Posts
    12
    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
  •