View Single Post
 
Old 03-19-2017, 12:05 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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