Thread: [Solved] Find and Replace character limit issue
View Single Post
 
Old 06-16-2025, 03:38 PM
macropod's Avatar
macropod macropod is offline Windows 10 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