Forum Discussion

AminuF's avatar
AminuF
Copper Contributor
Jan 10, 2021

Vba

I have a vba file I am developing for sales transaction. If I run the vba file and I add a product, I get a run-time error 1004, that unable to get the vlookup property of the worksheetfunction class...
Macros and VBA
AminuF's avatar
AminuF
Copper Contributor
Jan 10, 2021
how do I send the file?
JMB17's avatar
JMB17
Bronze Contributor
Jan 10, 2021
If you click on reply, instead of quick reply, you should see where you can attach a file - assuming there is no sensitive information. Otherwise, maybe copy/paste the applicable code. An incorrect argument being passed to the vlookup function may be the problem.
    • JMB17's avatar
      JMB17
      Bronze Contributor
      Jan 10, 2021
      The vlookup functions appear to be working okay for me. Is there a particular procedure and line that is problematic, or are there circumstances (userform inputs) where it's not working?

      You could also be getting that error if the value being looked up doesn't exist in the table.

Resources