Update content in table adds a new column

gmayor · #4 03-16-2017, 11:03 PM

When working with cell ranges, be aware that the cell range includes the cell end character. You are more likely to get the results you are seeking if having set the range, you remove the end character from the range (whether copying or pasting) e.g.

Code:

Set rng_Paste = UserDoc.Tables(i).Cell(MyCell.RowIndex, 1).Range
rng_Paste.End = rng_Paste.End - 1

Note also that there is no need to copy and paste when working with ranges. You can simply write the formatted value of the source range to the target range e.g.
TargetRangeName.FormattedText = SourceRangeName.FormattedText.
Your last example code does not work with two documents and their corresponding tables.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Loop and Update Content Controls with value	vss712	Word VBA	7	08-27-2015 08:56 PM
Update fields and Tables of Content with one macro	brent chadwick	Word VBA	7	03-11-2015 07:21 AM
Combine Different Word files into one file and update Table of Content	tejaspareek	Word VBA	4	11-04-2014 05:50 AM
How to align And center the content of the column in a table?	Jamal NUMAN	Word	1	05-02-2011 05:47 PM
SOS - cannot update table of content properly	Lee	Word	5	02-04-2011 12:59 PM