Cell formatting in Excel

Hi There,

I have a scenario like to format a cell in the excel as same as its previous cells.

Example,

I have an input file with 10 columns. While processing i am adding 5 columns in the excel to fill the output values.

I want to format the additional 5 column headers as same as the 10 input column headers. Is it possible?

If so, how to acheive it? Please help!

TIA

Hi,

How about CopyPasteRange as the following?

Sample
Sample20240509-3.zip (10.8 KB)

Regards,