View Single Post
 
Old 09-18-2012, 02:38 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The 'Rng.End = Rng.End - 1' is used because, when you select a cell range, you get the end-of-cell marker, which you don't want when you're going to paste the content somewhere else. What the code does instead, is to insert a temporary paragraph break before that, so as to keep the cell's paragraph formatting for whatever is the cell's last paragraph, then copy everything except the end-of-cell marker.

Regarding the string, are you wanting to keep the table, or just the string? Is it a particular string? How many cells are on the first row?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote