Currently I manually insert a new line of data into a worksheet from an
external source then using a macro I reformat the fill,font & alignment of
the row.

Within the inserted row at columns H & I - I want to copy the format of the
of the inserted row minus one's columns H & I (ie highlight current Row
-1(H:I) and paste special the format into inserted row (H:I)

Thank You