Insert row + copy cell formula's error

Hi,

I have very basic VBA knowledge (self taught).
Currently I am trying to insert a row in the range where I selected the cell.
At the moment I am stuck with following code:

Please Login or Register  to view this content.

I receive following error when I click the button:

"Run-time error '1004': AutoFill method of Range class failed"

When I push the button, a new row is inserted but then it highlights following code when I debug it:

Please Login or Register  to view this content.

I attached an image of an example how my table looks like...

excel table.PNG

within the range, the cells in the first column are merged together.
Is it possible that it has something to do with the merged cell?

Sidequestion:

Example: I select cell B3 --> push "add row" button --> new row is inserted

excel table 2.PNG (example of what the result is)

It is always under the first row that a new row is inserted. How can I change the code to insert a new row under the last row?

Thank you in advance for all the help!!

Kind regards,
MeerskiD

attach please xlsm sample file, not png

you have some merged cells in column A, you can not select a single row with them.
eliminate column A, the your code works without errors
but you can solve with

Please Login or Register  to view this content.

Originally Posted by MeerskiD

the macro does not copy formula's.
Do you might know how I can fix this?

Nevermind, it does work! Thank you Patel45!!