Add Rows by Macro button keeping formula format same as row above

  • Re: Add Rows by Macro button keeping formula format same as row above


    Hello,


    There are several solutions ... what about a double-click event macro located in the sheet module ...



    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Re: Add Rows by Macro button keeping formula format same as row above


    Hey Carim,
    This works partially. There is a #Value error appearing in row A. The numbering seems to start from A27. It should ideally start from A28.
    Also, I intend to put in a rectangular box which reads "Insert Row" next to the table and once the client presses this button a new row needs to be added. Ideally a single click.
    Is there any way this macro can be assigned to that button? You can try checking if its feasible on the spreadsheet attached.


    Thanks in advance.

  • Re: Add Rows by Macro button keeping formula format same as row above


    Hello ...


    Do not hesitate ... to give your feedback ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!