VBA Copy Text issues

gmayor · #1 04-17-2023, 01:46 AM

You have a mix-up with missing variables and incorrect variable types.
Note that it is good practice to add Option Explicit to the top of your modules, which will make it easier to spot such issues.
Your code doesn't read values from either workbook for use in the search. You need to read the values from the worksheet you want to reference into an array in place of the fixed array in the code at
https://www.msofficeforums.com/word-...ding-list.html then loop through the values. I posted code showing how to do this at https://www.msofficeforums.com/word-...ont-style.html

syl3786 · #2 04-17-2023, 02:26 AM

Quote:

Originally Posted by gmayor

You have a mix-up with missing variables and incorrect variable types.
Note that it is good practice to add Option Explicit to the top of your modules, which will make it easier to spot such issues.
Your code doesn't read values from either workbook for use in the search. You need to read the values from the worksheet you want to reference into an array in place of the fixed array in the code at
https://www.msofficeforums.com/word-...ding-list.html then loop through the values. I posted code showing how to do this at https://www.msofficeforums.com/word-...ont-style.html

Thanks for your reply. But the second link is related to mailmerge hyperlinks, not copy text...... may i aks if you can provide the URL?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Issues with a copy of a Contents Table!	KirstyAmanda	Word	2	07-20-2020 02:51 PM
Font issues when copy content from MS Word.	ArchanaV	Word	3	06-29-2016 01:02 PM
Issues with text in circle shapes that I am having	damefrombrum	Word	0	12-01-2015 08:05 PM
Page Up & Copy/Paste Issues	weamish	Word	10	02-01-2014 08:25 PM
Copy and Paste issues in Outlook 2007	Oncilla	Outlook	6	12-13-2010 01:00 PM