![]() |
#4
|
||||
|
||||
![]()
There is no reference to ·Firstline or ·Secondline in your code, so it's a bit hard to understand what you mean. That said, it appears you find text is in column B of the 'LookUp' sheet and the replace text is in column C of the 'Answers' sheet. The key to your problem would appear to be whatever the relevant cells contain - especially for the 'Answers' sheet.
We'd be able to understand the issues better if you provided both sample document and a workbook with some sample data. You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen. PS: When posting code, please use the code tags, indicated by the # button on the posting menu. Without them, your code loses much of whatever structure it had.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Select Cell Text to paste into Find/Replace | CBarry | Word VBA | 2 | 02-16-2017 04:37 AM |
![]() |
iiiiifffff | Word VBA | 16 | 06-04-2016 01:47 AM |
![]() |
rohanrohith | Word VBA | 3 | 11-27-2014 01:08 PM |
Macro to find coloured text and replace with form-field/formtext containing that text | tarktran | Word VBA | 1 | 11-26-2014 08:12 AM |
![]() |
bennymc | Word VBA | 1 | 01-27-2014 04:23 PM |