VBA to add row at row 4 from column A to L only and not affecting any detail from Column M onwards. Has VBA to add new row.

[nscaria00]

I have a macro to insert new rows at A4. But whenever i add new row, obviosuly it's shifting rows from Column M onwards.
I would like to have Column M onwards stay same (not adding any new rows or affecting any graphs/ drop downs in that range.). I am attaching screen shot for your quick reference.

Currently whenever I add row, all graphs are getting messed up, affecting macro in that area (Column M onwards). I select year from Column Q and run macro for Summary.

My Insert row macro for A4 is as shown below:

Sub AddBlankRowAtA4()
' Insert a new blank row at A4 for columns A to L
Range("A4:L4").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
End Sub

 

[Micron]

You don't want to insert row, just insert cells. You can select the range, right click and choose Insert...
Then select to shift down and ok. Or use
Range("A4:L4").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove

 

[nscaria00]

I currently have this code, but it does move all rows from Column M as well.

Sub AddBlankRowAtA4()
' Insert a new blank row at A4 for columns A to L
Range("A4:L4").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
End Sub

 

[Micron]

I don't see how that's possible. Works for me. Are any columns between A and M hidden?
Before:

After

 

[nscaria00]

Thank you! It works.

 

[Micron]

Glad I could help and thanks for the recognition, although I think post 2 is the solution. Post 4 is just the picture proof of it.