Code to add rows with formulas needs fixing

[Nitefox]

Im and having some issues with the following code which adds rows in-between my records, (below the active cell). The code keeps the formulas in the A, B, C, and F columns.

Please Login or Register  to view this content.

The user enters the number of rows to be added into tbRowAdd on the userform. If just one row is being added it works fine, however when more that one row is added it doesn't function correctly. Cells D and E from the second new row on dont get cleared.

I have also attached my workbook. The button Add Rows to run the userform is on the ReturnData sheet.

[p24leclerc]

modify those 2 lines of code like this:

Please Login or Register  to view this content.