|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
VBA Code to take data from a table in word document and place it in a summary table
This is in the same document. I tried to record the code, but I keep getting an error saying "value out of range". I essentially want to take a revision date from a certain part of a table and copy and paste it to a summary table in the same document.
This is what I tried: Code:
Sub Copy_To_Index() ' ' Copy_To_Index Macro ' ' Selection.MoveLeft Unit:=wdCharacter, Count:=16, Extend:=wdExtend Selection.Copy ActiveWindow.ActivePane.VerticalPercentScrolled = -40 Selection.MoveUp Unit:=wdLine, Count:=165 Selection.MoveDown Unit:=wdLine, Count:=4 Selection.MoveUp Unit:=wdLine, Count:=1 Selection.MoveRight Unit:=wdCharacter, Count:=3 Selection.PasteAndFormat (wdFormatPlainText) End Sub |
#2
|
||||
|
||||
Evidently your document has more than one table. Which table in the document are you:
• copying from • copying to? For each of those tables, what is the cell address you're: • copying from • copying to?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Insert table in document - automatically updates second table in summary? | Mechanic | Word | 2 | 08-01-2012 09:44 PM |
Place table over image as background | vavs | Outlook | 1 | 08-15-2011 09:32 AM |
adding table to a particular place | hklein | Word VBA | 2 | 07-25-2011 01:45 AM |
How do I dynamically update data in a Word Document from a database table | RSchmidt | Word | 1 | 07-14-2011 04:27 PM |
Excel data to Word table | Jaymond Flurrie | Word VBA | 2 | 02-27-2011 07:42 PM |