Thread: find/replace from excel list to word doc not keeping original sentence case from excel list
View Single Post
 
Old 07-20-2024, 05:46 AM
Italophile Italophile is offline Windows 11 Office 2021
Expert
  
Join Date: Mar 2022
Posts: 563
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default
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
Reply With Quote