How to center print title in dynamic print area?

Originally Posted by Ariful Islam

I have some text in A1, A2 and A3 of my data sheet, I want to keep the data of these three cells A1, A2 and A3 as a print title and across the center of width of dynamic print area.
That is, I want the print title of the dynamic print area to be center across dynamic area. Note that the dynamic print area is generated by a VBA code. Can anyone help me with this?
(Minor changes have been made to correct errors and simplify interpretation. Also attached files.)
VBA Code:

Please Login or Register  to view this content.

Thanks ChatGPT!

Originally Posted by jolivanes

Where does the quoted section in Post #2 come from?

It's been almost a week since I posted, I thought maybe there was a mistake in my question, or maybe no one noticed my post in the crowd of posts. So I removed the code. Sorry for that.

Originally Posted by jolivanes

No problem. Thanks for the explanation. Did you solve it?
My take on it would be something like this.

Please Login or Register  to view this content.

Print from Row 4 on down or from wherever.

Thanks for your solution. Your solution is more Compact and easier then ChatGPT.