find/replace from excel list to word doc not keeping original sentence case from excel list

		Microsoft Office Forums > Microsoft Word > Word VBA
find/replace from excel list to word doc not keeping original sentence case from excel list

FAQ

Thread Tools

Display Modes

07-20-2024, 05:46 AM

Italophile Italophile is offline

Windows 11 find/replace from excel list to word doc not keeping original sentence case from excel list

Office 2021

Expert

Join Date: Mar 2022

Posts: 563

Have you checked that the array contains the values in the correct format? There is a difference between the Value and Text properties of an Excel Range. Text returns the formatted text whereas Value returns the underlying value. You could try changing:

Code:

myarray = xlsheet.Range("A1").CurrentRegion.Value

To:

Code:

myarray = xlsheet.Range("A1").CurrentRegion.Text

Tags

sentencecase

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find, Replace using Excel List	pushpi004	Word VBA	16	02-20-2024 06:50 AM
Find and Replace from Predetermined list of Text for Both Find and Replace	dminor	Word VBA	1	08-16-2022 03:40 PM
How to import list from Excel into drop-down list into word	ahw	Word VBA	43	02-28-2020 08:11 PM
Advantages of List in Excel vs List in Word?	Peace Freak	Excel	3	04-08-2017 06:15 PM
Having a Drop-down list in Word referring to an Excel list	celias	Word VBA	3	07-11-2016 11:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:39 PM.