I need some help to create a Macro to insert a row. I have achieved it with the record a macro function but there is one element that doesn't work the way I need. I want to assign this macro to button and when pressed it will ad a row under row 26. I want some cell to have copied text from above and some copy only the formula. I have achieved all this true the record macro. The issue is once the macro has run once the second time I want it to insert row below row 27. The next time below row 28 and so on. Anyway to achieve this.
Bookmarks