Format a PivotTable
 

I am trying to:
Loop through cells in Column A
If the cell is empty then
format the cells from 1 cell to the right to count of used cells
to the right with a line on top
go to next cell
do until cell equals "Grand Total"