will that not leave it as a fomula. I need to be able to copy and paste it
as we will be running about 25 instances the same day all with differnt info

Patrick Molloy wrote:
you mean one row? that was covered in my code earlier

why not just have a formula
=A1 & B1 & C1 & D1 & E1

currently I have it so that it reads the entire document in columns A-D
and E
[quoted text clipped - 24 lines]

thanks.

--
Message posted via http://www.officekb.com