View Single Post
 
Old 06-24-2014, 06:53 AM
jpb103's Avatar
jpb103 jpb103 is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: May 2014
Location: Thunder Bay, Ontario
Posts: 58
jpb103 is on a distinguished road
Default Copy paste from RTF into cell causes extra lines to be created

Hey guys,

I've got a macro that copies the contents of an rtf file (one or more bullet points) into a cell in a table in word. A new row for the data is created each time. My problem is that, the first row of the table puts an extra line in, and every subsequent row puts an extra line and a bullet point. I've tried find/replace without much success, but since for some reason the first row is not like the others I'm not sure this approach will work properly.
I've tried multiple combinations for the .Text of the .Find method, here is an example:
Code:
Selection.Find.Text = vbCrLf & Chr(149) & ""
This example removes all CrLf and bullets in the row. (not the droids I'm looking for).
Any help would be appreciated.
Reply With Quote