Thread: How can I trap this Vlookup error in a VBA macro
View Single Post
  #7   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
Hi Richard,

An alternative to your test could be :
If cell Like "[A-Z]####" Then
once the pattern is identified or not, do This or That ...

HTH
Cheers
Carim

Reply With QuoteReply With Quote