VBA Syntax Error when replacing

[loribear180]

Hello everyone,

Last year I received help in creating the code attached. My export changed and now I need to update the replace parameters, however, are there limits to what can be replaced? I'm trying to replace an entire paragraph with a simple 'Y' but I keep receiving a 'Syntax Error' when I try to run the code.

My export has 6 different answers that I need to replace with simple Y or N. The specific language I'm struggling with reads:
Veteran. The individual is defined as an individual who has served in (and has been honorably discharged from) the following branches of service: The U.S. Army, Navy, Air Force, Marine Corps, or Coast Guard or the U.S. Public Health; Service under Title 42, United States Code, Section 201; The Texas Military Forces as defined by Texas Government Code, Section 437.001; or an auxiliary service of one of the branches of the U.S. Armed Forces.

Am I having this issue because it's too long of an answer and contains parentheses, colons, semi-colons, and every other punctuation mark? This is obviously not my expertise and I can't figure out what's wrong, I tried setting MatchCase to True hoping that would possibly fix it, but nothing. Again, I really appreciate your assistance and patience.?

 

[Fluff]

You could shorten the string & use a wildcard like

Selection.Replace "Veteran. The individual is defined as an individual who has served in (and has been honorably discharged from) the following branches of service: The U.S. Army, Navy, Air Force, Marine Corps, or Coast Guard or the U.S.*", "Y", xlPart, , False, , False, False

 

[loribear180]

You could shorten the string & use a wildcard like

Selection.Replace "Veteran. The individual is defined as an individual who has served in (and has been honorably discharged from) the following branches of service: The U.S. Army, Navy, Air Force, Marine Corps, or Coast Guard or the U.S.*", "Y", xlPart, , False, , False, False

Fluff thank you so much, that did it!! I learned what a wildcard can do

 

[Fluff]

Glad we could help & thanks for the feedback.