adding a row of cells with formatting and dropdowns

[smithjacobky]

So I have a multi-tab inventory sheet
All I want to do is add a group of cells at any under the row I have currently selected with all its formatting

The closest I have been able to come to it is to create a "formatting" sheet with the range and formatting I want and try to copy it to the range of cells but it only affects one row rather than adding where I want it.

Private Sub CommandButton1_Click()
'
Selection.Offset(1, 0).Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Sheets("Formating").Select
Range("A16:H16").Select
Selection.Copy
Sheets("EEC`").Select
Selection.PasteSpecial Paste:=xlPasteFormulasAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
End Sub


I am new to this but trying thanks in advance

[smithjacobky]

It kinda works except it only affects one column instead of adding a row of 8 cells