Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-03-2019, 01:26 PM
DIMI DIMI is offline Replace word in excel Windows 7 32bit Replace word in excel Office 2007
Advanced Beginner
Replace word in excel
 
Join Date: Aug 2017
Posts: 37
DIMI is on a distinguished road
Default Replace word in excel


Good afternoon
I have put vba to replace [orange] with red and replace [orange..juice] with green, but the vba replace [orange..juice] with [red..juice].Why the vba couldn't to convert?
Reply With Quote
  #2  
Old 12-05-2019, 02:07 AM
KunleExcel KunleExcel is offline Replace word in excel Windows 8 Replace word in excel Office 2010 32bit
Novice
 
Join Date: Jun 2016
Location: Nigeria
Posts: 17
KunleExcel is on a distinguished road
Default

Dear DIMI
Make your LookAt argument xlWhole. i.e LookAt:xlWhole
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Find and Replace, can Word stop after each Replace? wardw Word 1 06-08-2017 02:47 PM
Find and replace in word document repeated for every item in excel spreadsheet Daniell Word 1 02-17-2015 04:38 AM
Replace word in excel replace data from variable with "sub and super script" from excel to word by vba krishnaoptif Word VBA 9 06-22-2012 05:08 AM
Replace word in excel How to Replace Excel Cell Value in MS word by VBA.... krishnaoptif Word VBA 4 06-18-2012 10:23 PM
Excel 2007 replace Jim WV Excel 2 07-17-2011 01:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft