Could I use part of your script to place a style on each rows?

I have a given style name on row 1=".Name of account_header"
I have a given style name on row 2=".Name of Tbl_header"
I have a given style name on row 3=".Period_header"
I have a given style name on row 4=".empty_row_space_header"

But what will happen if I have a table with less rows?
Like there are sections where it's only two rows, and some 1.

Does this resolves the issues = On Error GoTo 0? or On Error GoTo Next?

Maybe I should have created a new Thread, but I wanted to ask in regards to your start of the script to have it go in headers. Not sure how to do it, but was wondering if its doable?

Any insights, I would be grateful

Cendrinne