VBA code with autofill when inserting new rows within a specific column range

[valmir]

Hello everyone!
I have this code which is a generic code that is actually working. However, it affects the entire row. I need this code modified so that it will make changes from column A to DO.
This is the code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Updateby Extendoffice 20160725
Cancel = True
Target.Offset(1).EntireRow.Insert
Target.EntireRow.Copy Target.Offset(1).EntireRow
On Error Resume Next
Target.Offset(1).EntireRow.SpecialCells(xlConstants).ClearContents
End Sub

Please help!

 

[valmir]

Ok got it! I thought there was a way to keep changes within a certain range, both column and row-wise

 

[Fluff]

The only way would be to insert a row & then delete another further down the sheet.

 

[valmir]

Yeah that's what I've been doing. Thanks!

 

[Fluff]

You're welcome & thanks for the feedback.