Vlookup macro run time error
Thanks
I had my result as string not variant
"Dave Peterson" wrote:
Try dropping the .worksheetfunction. from the line:
dim ReaderResult as Variant 'note that it's a variant
readerresult = application.vlookup(....)
if iserror(readerresult) then
'it wasn't found
else
'it was found
end if
If you use the .worksheetfunction stuff, you'll have to trap for the error.
dim ReaderResult as String 'long, whatever
on error resume next
readerresult = application.worksheetfunction.vlookup(....)
if err.number < 0 then
err.clear
'not found
else
'found
end if
on error goto 0
I find the first method easier to use.
Daveh wrote:
I get Run time error 1004 Unable to get the Vlookup property of the worksheet
function class as an error message when i run the following macro command
Readerresult = application.worksheetfunction.vlookup(userselectio n,
classlistrange,2)
Excel 2000.
Hope you can help !
--
Dave Peterson
|