Results 1 to 10 of 10

Iserror/Index/Match in VBA

Threaded View

  1. #1
    Registered User
    Join Date
    10-13-2008
    Location
    Australia
    MS-Off Ver
    2007
    Posts
    85

    Iserror/Index/Match in VBA

    Hi All,

    I am wondering if you could please help me with the below code I have.

    For Each cell In Range("H4:H60")
    
    If IsError(Application.WorksheetFunction.Index(Sheets("PAN").Range("I1:K50"), Application.WorksheetFunction.Match(Range("B" & cell.Row), Sheets("PAN").Range("K1:K50"), 0), 1)) = False Then
    Range("B" & cell.Row).Text = "HA"
    
    End If
    Next
    I've never done an iserror, index or match in vba, so it's something new to me and I'm not exactly sure as to how to go about it.

    Also, while I'm here can you please explain when to use "Application." before "WorksheetFunction" and when not to, as I'm having trouble finding the differences.

    Your help is greatly appreciated.

    Benno
    Last edited by benno87; 04-01-2009 at 09:04 PM.

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