VBA IF Statement Help

gmaxey · #25 03-20-2024, 03:06 PM

Shelley,

The reason for the replacement is code that I added to the CompoundCR procedure to replace 2 or more spaces with a singe space. That fixed that one issue where the CR number wasn't being picked up. You can take that out if you wish.

Code:

With oRng.Find 
  .ClearFormatting 
  .Replacement.ClearFormatting 
  .Forward = True 
  .Wrap = wdFindStop
  .MatchWildcards = True
   .Text = "[ ^s]{2,}"
   .Replacement.Text = " "
   .Execute  Replace:=wdReplaceAll
End With

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF Statement (again)	teza2k06	Excel	8	02-11-2022 08:41 AM
Converting a Select statement in Excel to an update statement	shabbaranks	Excel Programming	5	10-31-2018 11:47 PM
Need a little help with an if statement	cangelis	Excel	2	04-08-2015 05:55 PM
If statement, may be?	Tony Singh	Excel	6	03-04-2015 12:52 PM
Need help with If, Then Statement Please	cangelis	Excel	4	01-03-2014 09:10 AM