thanks! ill giver a go
in vb eof is reserved for 'end of file' so i never thought it could be a variable.