Find and Replace character limit issue

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Find and Replace character limit issue

06-16-2025, 03:38 PM

macropod

Windows 10 Find and Replace character limit issue

Office 2016

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

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]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Identifying Concentric Square Loops Special Character for Find & Replace	BrianS4	Word	5	07-08-2024 08:59 PM
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 07:16 PM.