help to adjust my macro code

You can turn on the macro recorder to get the code.

I selected the data in a document, turned on the macro recorder, set the parameters you wanted and below is the produced code.

Please Login or Register  to view this content.

Better yet, you can modify a style and apply that...

Here is one place to start...

Cross-posted at: http://www.techsupportforum.com/foru...e-1109801.html

Please read the Cross-Posting policy in rule #8: http://www.excelforum.com/forum-rule...rum-rules.html

Dear Jeff, kindly be informed that i already did record a macro as you did but it doesn't change values as i requested

i have to select each paragraph one by one then run macro, so i need to that change to applied all over the file without selection each paragraph


Administrative Note:
Hi Muhammad, as long as you are reading the forum rules...

As per Forum Rule #12, please don't quote whole post unless necessary -- it's just clutter.

Originally Posted by Muhammad Waheed

i have to select each paragraph one by one then run macro, so i need to that change to applied all over the file without selection each paragraph

As Jeff has already said:

Originally Posted by jeffreybrown

you can modify a style and apply that...

Modifying a Style applies the change to all paragraphs based on that Style, throughout the document, without the need to select anything.