problems with application.worksheetsfunction (vlookup)

[schzuki]

Hi

I'm running a code that looksup values in a different excel file and copies these back to my master file. I keep getting an error message with the following piece of code

Code:

Please Login or Register  to view this content.

I keep getting an error 1004, (application-defined or object-defined error). I cant figure out what I'm doing wrong

Can you guys offer some advice?

[6StringJazzer]

Not enough code or context to provide a diagnosis. The code for VLOOKUP looks OK, but the error could be happening in several places.

Is the file Workbooks(Name) open at the point where it is used? If the file is not open, the code will fail. Although Excel formulas can refer to external files without the file being open, VBA code cannot use a range expression like

Please Login or Register  to view this content.

if the file is not open.

How are these variables declared? At the point where the error occurs, what are the values of these variables?

• current
• regel
• rij
• taak
• Name