Results 1 to 8 of 8

Looping Find Function

Threaded View

  1. #1
    Registered User
    Join Date
    11-25-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    31

    Looping Find Function

    Hi,

    I am looking for a way to turn my current coding into a loop

    Sheets("Actual Schedule").Select
    Range("A1").Select
    i = 1
    h = 2
      'strr = ""
      'lastrow = Cells(Rows.Count, "B").End(xlUp).Row
      'findit = Range("F:F").Find(What:="BOFF", LookAt:=xlPart, After:=Range("" & Cells(Rows.Count, "F").End(xlUp).Row))
        
     
        Set findit = Cells.Find(What:="boff", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
            :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
            False, SearchFormat:=False)
        firstadd = findit.Address
        b = findit.Row
      Range(Cells(b, 5), Cells(b, 5)).Copy Destination:=Sheets(5).Cells(h, 1)
      h = h + 1

    I am not exactly sure how to loop it to find the next value with "Boff" and find the corresponding cell to the left to it.

    I'll keep looking for solutions in the mean time.

    Thanks
    Attached Files Attached Files
    Last edited by hkayani08; 04-02-2012 at 10:06 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1