Insert row on button position

[Q45]

How do I insert a row using a macro button that insert the row beneath the row that the macro button is touching?

 

[Q45]

I've tried it 100 times and I that's not working but I get the idea. That's exactly what I want but I just need to know how to complete it. I don't know what the missing link in the code is. Can you help?

 

[Juan Pablo González]

I think the problem you're having is the "type" of button you are using. Use a button from the Control Toolbar. Then, doubleclick on it, and paste this macro there:

Private Sub CommandButton1_Click()
ActiveCell.Select
CommandButton1.BottomRightCell.Offset(1).EntireRow.Insert
End Sub

 

[todd78]

Good response.........

Sales tracking sales tracking software Sales lead tracking software​