Results 1 to 8 of 8

Searching for a value but skip the first found value.

Threaded View

george1982 Searching for a value but... 06-14-2009, 07:02 AM
Andy Pope Re: Searching for a value but... 06-14-2009, 07:23 AM
george1982 Re: Searching for a value but... 06-14-2009, 07:55 AM
Andy Pope Re: Searching for a value but... 06-14-2009, 07:58 AM
george1982 Re: Searching for a value but... 06-14-2009, 08:06 AM
  1. #1
    Registered User
    Join Date
    07-07-2008
    Location
    Bath
    MS-Off Ver
    Microsoft Office 2007
    Posts
    42

    Exclamation Searching for a value but skip the first found value.

    Hi all,

    I have a macro with what I can search and works as I would like:

    Range("A1").Select
    Cells.Find(What:="Site 125", After:=ActiveCell, LookIn:= _
    xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
    xlNext, MatchCase:=False, SearchFormat:=False).Activate
    ActiveCell.Range(Cells(1, 5), Cells(8, 3)).Select
    Selection.Copy
    Windows("report_template.xls").Activate
    ActiveSheet.Next.Select
    ActiveSheet.Next.Select
    ActiveWindow.SmallScroll Down:=18
    Range("B1395:D1395").Select
    ActiveSheet.Paste
    Sheets("Dashboard").Select
    Application.CutCopyMode = False
    Range("A1").Select
    BUT I would like to be able to skip the 1st found value and copy only the second one. I don't know if that's possible or not.

    Thanks for your help,
    Regards,
    George
    Last edited by george1982; 06-14-2009 at 07:40 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