Thread: How can I trap this Vlookup error in a VBA macro
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
  
Posts: 510
Default How can I trap this Vlookup error in a VBA macro
Richard,

Could the following help ...
Result = Application.VLookup(x, MyRange,2,0)
if iserror(Result) then

to detect where somthing is going wrong ...

HTH
Carim

Reply With QuoteReply With Quote