jagdishmathikumar
New Member
- Joined
- Jun 10, 2011
- Messages
- 1
Hi,
I tried WorkSheetFunction.Vlookup() funtion as below
strName = Application.WorksheetFunction.VLookup(associateName, Worksheets("Sheet1").Range("C:C"), 0)
and I get runtime error as below
"Unable to Get the Vlookup property of the WorksheetFunction class".
Please can somebody throw lights here.
Please note that I have the same values that I vlookup in the target sheet.
Thanks in Advance,
jagdish
I tried WorkSheetFunction.Vlookup() funtion as below
strName = Application.WorksheetFunction.VLookup(associateName, Worksheets("Sheet1").Range("C:C"), 0)
and I get runtime error as below
"Unable to Get the Vlookup property of the WorksheetFunction class".
Please can somebody throw lights here.
Please note that I have the same values that I vlookup in the target sheet.
Thanks in Advance,
jagdish