Martin,

that saves a few lines, thanks! I think i copied that 'with' straight
out of the help, im still learning vba and it is quite a steep learning
curve but i think im getting there.....

I worked out why it bugged out, the loop that was in from my other sub
was looping itself into infinity, so i changed the code to add "SCA" to
the end of the number and then when it looped back it didnt find a
match again.

Duncan