I have a button on one of my sheets to allow the user to add rows. An input box pops up and asks them how many rows they would like to add.
Here's my code:
Dim NumberOfRowsInLog As Integer
Dim LastRowInLog As Integer
Dim RowsToAdd As Variant