Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-15-2021, 04:09 PM
mbcohn mbcohn is offline find and replace a number that's always in a table and always adjacent to a cell with known text Windows 10 find and replace a number that's always in a table and always adjacent to a cell with known text Office 2016
Advanced Beginner
find and replace a number that's always in a table and always adjacent to a cell with known text
 
Join Date: Jan 2021
Posts: 32
mbcohn is on a distinguished road
Default find and replace a number that's always in a table and always adjacent to a cell with known text

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.
Reply With Quote
 

Tags
tables, vba, vba find and replace



Similar Threads
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
find and replace a number that's always in a table and always adjacent to a cell with known text VBA Table – Search All Tables - Find & Replace Text in Table Cell With Specific Background Color 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft