I'd use:

"line1" & vbLf & "line2"
(vblf = alt-enter)
or
"line1" & vbnewline & "line2"
(vbnewline is platform independent--it'll be vblf in windows and vbcrlf on Macs
(I think).)

But both of them won't fix the problem when you paste to NotePad.

Did you try the code taken from Chip Pearson's site?

It worked ok for me.



rfusee wrote:

Dave,

I use the "line1" & vbCrLf & "line2" .....etc to force new lines within the
cell. Is there a better way?

THANKS!!!!!

"Dave Peterson" wrote:

I bet you have alt-enters in your cell to force new lines within the cell.

Maybe you can do the copying in your code:

I used the PutOnClipboard routine that Chip Pearson has:
http://www.cpearson.com/excel/clipboard.htm

With this sub:
Option Explicit
Sub testme()
PutOnClipboard ActiveCell.Text
End Sub

And then pasted (manually) into NotePad. No double quotes were inserted.

Chip has instructions that you have to follow (including the tools|references
with "Microsoft Forms 2.0 object library") on that sheet.



rfusee wrote:

I posted this yesterday, but noone replied. I'm hoping it's not because
there's no solution to my problem! Here's the deal...

I have a Cell in Excel which calls a VBA function which returns a long
string. The VBA function works correctly and the output looks correct in the
Cell. When I copy and paste that cell from Excel into Notepad, it adds
quotation marks around the beginning and end of the text. I can't figure out
how to make it so that doesn't happen.

Furthermore, if I copy and paste the adjacent Cell in Excel, which is also a
long string but one which I typed directly into the cell and not from a VBA
function call - there are not quotation marks around the text in Notepad!

Very, very frustrating...any help would be most appreciated...

--

Dave Peterson


--

Dave Peterson