Insert 1 Row where needed based on another one.

Could you use .FillDown instead of AutoFill? That should copy the the format and formulas from the row above. If that doesn't work you could always copy the row and then use pastespecial to paste the formulas and formats.