Transefeering info from several cells into one sheet.


Posted by jevee on February 23, 2001 3:36 PM

I have a vba command that transfeer info from several cells into one sheet. No i want to insert a standard text info which is supposed to be transferd in front of the information from the cell, i also want to have new line between each Cell.
This is the command im using:
.Body = Cells(r, 5).Value + Cells(r, 9).Value + Cells(r, 10).Value

Something like this is what i want:
.Body = "Preformatted text" Cells(r, 5).Value "new line" + "preformatted text" Cells(r, 9).Value "new line" + "preformatted text" Cells(r, 10).Value "new line"

Im sure this can be done easy but i need help from you experts. Quick answer will be appreciated
Regards
jevee




Posted by Dave Hawley on February 24, 2001 2:50 AM


Jevee, I can't see quite see what it is you are doing here, but maybe this will help.

For r = 1 To 5
.Body = 0
.Body = Format(Cells(r, 5), "yyyy") + Body
Cells(r, 5).EntireRow.Insert
Next


Dave
OzGrid Business Applications