Forum Discussion
HELP PLEASE RUN TIME ERROR 1004
Hi! I'm having a problem with running my macros. Can you please help? It kept on saying eun-time error 1004. And going to the code where you should run the userform.
Thank you for all your help!
1 Reply
In the lines
Inv_sh.Range("F2").Value = "=VLOOKUP(A2,Product_Master!B:G,4,0" Inv_sh.Range("G2").Value = "=VLOOKUP(A2,Product_Master!B:G,5,0"the closing parenthesis of the VLOOKUP function is missing. Change the lines to
Inv_sh.Range("F2").Formula = "=VLOOKUP(A2,Product_Master!B:G,4,0)" Inv_sh.Range("G2").Formula = "=VLOOKUP(A2,Product_Master!B:G,5,0)"(I used Formula instead of Value, but that's just a preference, for clarity)
