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

unable to get the vlookup property of the worksheetfunction class

This is a discussion on unable to get the vlookup property of the worksheetfunction class within the Excel Questions forums, part of the Question Forums category; Hi I have figured it out, it was because the column i was referencing was not the column in the ...

  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
    177

    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.

Page 2 of 2 FirstFirst 12

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