Thread: How can I trap this Vlookup error in a VBA macro
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Richard Buttrey Richard Buttrey is offline
external usenet poster
  
Posts: 296
Default How can I trap this Vlookup error in a VBA macro
On Sat, 8 Apr 2006 03:22:45 -0500, Carim
wrote:


Hi Richard,

Is your "JobNo" structured in a particular way ?

Carim

It's always 5 characters, with an initial alpha and four numerics if
that helps.

e.g. M0123

Thanks

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
Reply With QuoteReply With Quote