![]() |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
I have a series of documents that all contain identical formatting.
Each has a table that contains a cell with the value "Revision No." Then, in the cell just to the right of that first cell, there is another cell, containing a number. So it looks kind of like this: Revision No. 6 Except that "Revision No." and "6" are in different cells. So, I need to programatically (because there are many documents) update the numbers. I don't want to do a normal find and replace because, of course, the number 6 might occur in other places throughout the document, and I don't want to replace those. I only want to replace the one that represents the revision number. If this is too hard, then there might be other ways to identify the exact cell where the revision number occurs. It does tend to be in the same position, relative to the whole table, in every document. However, I am not 100% sure that there are no exceptions. |
Tags |
tables, vba, vba find and replace |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find and Replace rows in a table based on bold text. | OfficeAssociate99 | Word VBA | 2 | 07-26-2017 06:32 AM |
Select Cell Text to paste into Find/Replace | CBarry | Word VBA | 2 | 02-16-2017 04:37 AM |
Increase number in cell, based on value in adjacent cell | scottyb | Excel | 3 | 02-02-2017 03:51 AM |
![]() |
jc491 | Word VBA | 8 | 09-30-2015 06:10 AM |
Word VBA Find Table Text Shading Colour and replace with another | QA_Compliance_Advisor | Word VBA | 10 | 09-19-2014 08:36 AM |