Re: How can I trap this Vlookup error in a VBA macro

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Richard Buttrey <chaos.theory.nospam.removethis@xxxxxxxxx>
Date: Sat, 08 Apr 2006 10:35:34 +0100

On Sat, 8 Apr 2006 03:22:45 -0500, Carim
<Carim.25xsfm_1144484701.9155@xxxxxxxxxxxxxxxxxxxxx> 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
__________________________
.

Follow-Ups:
- Re: How can I trap this Vlookup error in a VBA macro
  - From: Carim

References:
- How can I trap this Vlookup error in a VBA macro
  - From: Richard Buttrey
- Re: How can I trap this Vlookup error in a VBA macro
  - From: Carim

Prev by Date: Re: Running Macro/VBA in multiple worksheets.
Next by Date: RE: Find Missed and Duplicated Numbers
Previous by thread: Re: How can I trap this Vlookup error in a VBA macro
Next by thread: Re: How can I trap this Vlookup error in a VBA macro
Index(es):
- Date
- Thread

Relevant Pages

Re: A new twist on the last problem (D3/NT)
... This synonym gave me all the alphas in the record ID so for the above ... data I got 1 to 3 alpha characters, which was great as it allowed me to ... wanted just the first alpha part before the numeric, ie R, RC, SZY. ... and the following numerics can vary, but the end alpha (after the ...
(comp.databases.pick)
A new twist on the last problem (D3/NT)
... This synonym gave me all the alphas in the record ID so for the above ... data I got 1 to 3 alpha characters, which was great as it allowed me to ... wanted just the first alpha part before the numeric, ie R, RC, SZY. ... and the following numerics can vary, but the end alpha (after the ...
(comp.databases.pick)
Re: DEFCON 16 and Hacking OpenVMS
... To reproduce this, apparently one is to enter exactly 511 characters ... Of course it could even be Alpha chip type ... Sampsa's report of VMS vulnerabilities in the Defcon 16 slides. ...
(comp.os.vms)
Re: looking for a webapp bruteforce video for non-techies
... Sure it is a dictionary/leet word variant, ... characters actually carry plenty of entropy (if mixed case and numerics ... I know all about secure passwords, entropy and stuff like ...
(Pen-Test)
Re: "Dollhouse" = Duh-house
... But then, why does Alpha go through the trouble of having an agent, ... Didn't this Richard pose as someone who ... characters with a bit more meat on their bones. ... I praise what's praiseworthy, I trash what's trashworty. ...
(rec.arts.tv)