VBA Code to Insert Multiple Rows of Data After Active Row/Cell

I need to add numerous rows (7) of the same data between rows if an item has been added for it to maintain my numbering system. Previously I have been selecting the rows and going copy – insert copied cells and adjusting the data accordingly but this is messing up my borders and is causing some errors in some data being not being replaced with correct numbers/description. I’m wondering if there is a macro I can use to insert multiple rows of existing content? See photo for example (column J has formula H-I)

VBA Code to Insert Multiple Rows of Data After Active Row/Cell

Participant Asked 1 min ago in VBA: Macros.
Add Comment
0 Answer(s)
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.