Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: unable to get the vlookup property of the worksheetfunction class

  1. #11
    Board Regular
    Join Date
    Apr 2008
    Posts
    265

    Thumbs up Re: unable to get the vlookup property of the worksheetfunction class

    Hi

    I have figured it out, it was because the column i was referencing was not the column in the range. But it is now so its working fine.

    Thanks to all who helped me!

  2. #12
    Board Regular
    Join Date
    Apr 2013
    Location
    Ensenada, BC, Mexico
    Posts
    178

    Default Re: unable to get the vlookup property of the worksheetfunction class

    Quote Originally Posted by VoG View Post
    Using WorksheetFunction will cause a VBA error if VLOOKUP returns #N/A. Try

    Code:
    PPNewIR.Cells(Nrow, 6).Value = Application.VLookup(cell.Value, PPNew.Sheets("ConvertManual").Range("A2:Y3000"), 10, False)
    See here for a discussion Daily Dose of Excel Blog Archive The WorksheetFunction Method
    Thanks. It was driving me nuts.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com