Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Find and Replace character limit issue Find and Replace character limit issue
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 06-16-2025, 03:38 PM
macropod's Avatar
macropod macropod is offline Find and Replace character limit issue Windows 10 Find and Replace character limit issue Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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
Text box? What is in the cells concerned on those occasions? And what does StrRep return?

You might try:


Code:
StrFnd = WkSht.Cells(r, 1).Text: StrRep = WkSht.Cells(r, 2).Text
instead.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 06-17-2025, 03:33 AM
kilroy kilroy is offline Find and Replace character limit issue Windows 10 Find and Replace character limit issue Office 2016
Competent Performer
Find and Replace character limit issue 		 
Join Date: Sep 2016
Location: Southern Ontario
Posts: 122
kilroy is on a distinguished road
Default
Paul I found an issue with the saved templates late last night. It wasn't an issue with the code. I will be testing this morning.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace character limit issue Identifying Concentric Square Loops Special Character for Find & Replace BrianS4 Word 5 07-08-2024 08:59 PM
Find and Replace character limit issue Find/Replace of funny character WJSwanepoel Word 2 06-03-2020 01:58 AM
Find & replace a character in a particuler position klllmmm Excel 1 07-27-2016 11:27 PM
Character Limit Mulith Mail Merge 2 11-03-2014 03:20 AM
Wildcard Find/Replace deletes extra character Cosmo Word 1 06-20-2014 08:49 AM

Other Forums: Access Forums

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

Contact Us - Privacy Statement - Top

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