VLookup() Run-Time Error '1004'

Getting Run-Time Error '1004'
Unable to get the Vlookup property of the WorksheetFunction Class

I am not sure why. In Debug mode the variables are all correct.

Please Login or Register  to view this content.

UNABLE TO ATTACH FILE AS THEY'RE HUGE.

this was previous code that worked.

Please Login or Register  to view this content.

Hi

worked for me. Are you sure your sheet names are correct, and that there is relevant data to find?

rylo

Yes, the sheets are name correctly. That was the first thing I checked. Several times.
There is a significant amount of data to find.

You checked the code in the top section? The second set of code is what I had working previously. I am trying to get away from hvaing to read values from the spreadsheet as I am having the user enter data through InputBox.

I was able to resolve the problem by defining drg_code as a Variant instead of the String it was defined as.