you mean one row? that was covered in my code earlier

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



"Darrell_Sarrasin via OfficeKB.com" <u33691@uwe wrote in message
news:97fb6c7c208d6@uwe...
currently I have it so that it reads the entire document in columns A-D
and E
combines the lines in one cell so I can copy and paste it.

I want to be able to take it and instead of doing the entire document just
run it on one line only.

Patrick Molloy wrote:
i don't get the question. Do you want this for a single cell?

this would work for a selected cell or range

with selection
.Offset(, 5) = c & ", " & .Offset(, 1) & ", " & .Offset(, 2) & ", " &
.Offset(, 3)
End With

or for a specific cell it would be

with Range("A1")
.Offset(, 5) = c & ", " & .Offset(, 1) & ", " & .Offset(, 2) & ", " &
.Offset(, 3)
End With

Can I please get help with the following code.

[quoted text clipped - 19 lines]

thanks.

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