VBA Word - Find And Replace

Question

I'm trying to create a VBA Macro in Word that will search for some text and apply a specific style to it. Before I automate it I'm trying to do it manually via the Find and Replace tool. Here's what I'm doing...

Open a word document with the text: This is the first sentence in the word document.
Make the phrase "in the" to be bold.
Open up the Find and Replace Tool via Edit --> Replace.
In the "Find what:" field only have Format: Font:Bold
In the "Replace with:" field only have Format: Style:Heading 1
Click on "Replace All"

Notice how the entire sentence has been changed to "Heading 1". I only wanted the areas in the document that were "bold" to be in "Heading 1" not the whole sentence.

What am I doing wrong?

Did you already try Italic format? Without testing it myself I'd guess your result is due to the fact that Heading 1 is paragraph format. — Filburt
– Filburt, Commented Feb 17, 2012 at 11:39
What does it mean "paragraph format"? Does this work differently? — Ann Sanderson
– Ann Sanderson, Commented Feb 17, 2012 at 18:34
Paragraph means that - as you have seen - will format everything from the beginning of the line to the next line break (in your case the whole sentence). — Filburt
– Filburt, Commented Feb 17, 2012 at 22:01

Toby Allen · Accepted Answer · 2012-02-17 23:14:33Z

1

A Heading is a heading.

If you change any part of the sentence to Heading1 the whole sentence becomes the heading. If you want it to be bigger, my suggestion would be to increase the font size not make it a Heading!

answered Feb 17, 2012 at 23:14

Toby Allen

11.3k12 gold badges80 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA Word - Find And Replace

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related