Chris, Totally confused me with your posts...

End If

row = row + 1
Wend
End Sub

this does'nt work wend without while comes up, I gather this is put at
the end of the code???

If it does work but I've misread something could you put it in the
code in the right place? thanks