Storing vlookup as variable in VBA

[farzyness]

Hello all,

I'm looking to store different values to a variable that would be holding a vlookup function. I'm storing the variable as a double, but one of the criteria that my macro checks is to make sure that the vlookup is actually succesful, (i.e. if iserror(application.vlookup(BLAHBLAH)) then).

Here's the example I'm talking about:

Please Login or Register  to view this content.

Is this something that is allowed in VBA? Do I have to declare the variable as a certain type?

Any help would be great. Thank you very much

[StephenR]

If I understand correctly, I think you have to declare it As Variant.

[shg]

Your code isn't doing what you think. It's doing the lookup once, prior to the loop, and then using the result repeatedly.