I am trying to use VLookup function in Excel VBA.
Eventhough I use the syntax application.WorksheetFunction.VBA(______)
it throws up an alarm Unable to get the VLookup property of the WorksheetFunction Class.
I was successful in using the same syntax for Max function.
Is it the limitation with Excel that we cannot use functions?
Please help.
Thanks in advance Guru
Eventhough I use the syntax application.WorksheetFunction.VBA(______)
it throws up an alarm Unable to get the VLookup property of the WorksheetFunction Class.
I was successful in using the same syntax for Max function.
Is it the limitation with Excel that we cannot use functions?
Please help.
Thanks in advance Guru