"Greg" wrote in news:1116247564.625166.297570
@g43g2000cwa.googlegroups.com:

Jezebel,

Please enlighten. How would you use Instr to return the reference?



I'll have a go (someone else will make a prettier one)


strRef = Mid$(oRg.Fields(1).Code, InStr(oRg.Fields(1).Code, "_Ref"), 13)


The only thing I don't like is the hard coded '13'. Does anyone know
a pre-defined system constant for a hidden bookmark length? For that
matter, is 13 even guaranteed?

-Max