Command button to add a new row in G14 with these formulas?

[Mr.Castle]

I need a command button to add a new row in G14 with this formula in L14 ' =IFERROR(SUBSTITUTE(LEFT(J14;FIND(" ";J14));"pág";"")+0;"") ' and this formula in M14 ' =IF(J14="";"";K14/LEFT(J14;FIND("pág";J14)-1)+0) ?

[jeffreybrown]

Hi Mr. Castle,

Turn on the macro recorder as you initiate your steps described above and then attach to a command button.

[Mr.Castle]

Hi , i recorded the macro, now how to attach to the command button?

[jeffreybrown]

On your worksheet, select on the ribbon, Developer tab, insert, forms control button.

https://www.youtube.com/watch?v=eLWRqGGdGEQ

Click on the Button (form control) and then place on the worksheet.

After you drop the command button on the worksheet you will be prompt to assign the macro.

Also, if you post your macro here (with code tags), we can show you how it can be cleaned up.

When using the macro recorder, the recorder records steps which are not necessary.

Beyond the macro recorder

[Mr.Castle]

It worked,

Thank you Jeff

[jeffreybrown]

Bitte Mr. Castle. Happy to help and thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.