Copy and pasting from excel using vba code ......its putting quotes at start and end

hi,

i have a problem where i am copying and pasting cell values from excel manually to say the vba code enviroment and after i paste its adding quotes to the start and end of my text.

what can be done to prevent this?

ok, what i found is if i copy a range of cells from excel and paste into word then it does NOT add the extra quotes....i guess this is good enough for now.

but if you know of a better soln please let me know. note: cells i am copying have multiple lines in each cell that i am copying.

It's because you are copying multi-line cells.
One way is once you have pasted into the VBE, select the text you've pasted, then CTRL H, & replace the " with nothing. just make sure you click Selected Text