Why is objRange.ParagraphFormat.Align=1 applying to objRange and objRange1? Help me fix it

[Sprong]

I'm trying to apply a center align to ONLY the 'create header' section objRange. I managed to keep bold formatting within objRange, but for some reason objRange.ParagraphFormat.Alignment = 1 is also centering the text in the table. I realize I'm probably making a pretty basic mistake but I'm pretty new to coding and don't understand what I'm doing wrong. I am generating the word report from an excel macro so please let me know if this is in the wrong section.

Please Login or Register  to view this content.

[macropod]

That's because you've pointed both to the same range. Your code could also be greatly simplified:

Please Login or Register  to view this content.

[Sprong]

Thank you @macropod for this solution. I know the code was far from simplified but I was still just trying to piece it together to do what I needed it to. If I wanted to have another header section immediately below the table, how would I need to alter the code you've provided?

Please Login or Register  to view this content.

I've tried copying it but it overwrites everything. I'm trying to learn how to create distinct ranges of text; I'm unsure how to change this to do that.

[macropod]

What would be in that 'another header section immediately below the table'?