"JOHN YOUNG" wrote in message ...

2nd - is there a vlookup macro or vb code available to
have a look at. I have had a search on the knowledge
base but cant seem to find one.

Kind regards

John Young

Hi John, this is the vlookup code l use.. just something for you to
look at
in case it helps..

Application.WorksheetFunction.VLookup(ActiveSheet. Cells(xlrow,
39).Value, Range("br1385:bv1485"), 5, True)

seeya ste