Worksheet Functions in vba

[kishen1912]

I am using the following statement

Please Login or Register  to view this content.

can you please whether this is legal... my vba compiler is crashing when i am trying this

[DonkeyOte]

Assuming i,j & range1 are all valid then perhaps:

Please Login or Register  to view this content.

[romperstomper]

There's nothing wrong with the syntax itself, assuming the sheets exist and the variables are correct.

[kishen1912]

How come then i am getting the following error

unable to get vlookup property of worksheetfunction class

[kishen1912]

@DonkeyoTe..

Thanks for the tip..

works like a charm

[romperstomper]

I thought you were getting a compile error, not a runtime one. The issue, as solved by DO, is that the WorksheetFunction.VLookup returns a runtime error, not an error value, if the value is not found in the table. Using Application.Vlookup returns an error value instead.