As title, enter the cell Numbers, and then insert the corresponding number of lines! And every time input, before inserted row changed also

CodePudding user response:

Try the Worksheet_Change ah

CodePudding user response:

Requirement description is not clear, it is in a fixed number of input of a cell? Or a column? Or say any cell? Where the insert? The current sheet? Or have a goal sheet? Where to put? Somehow make a figure come up

CodePudding user response:

I think is in the following events to capture the number of input, and then call the insert action process,
Private Sub Worksheet_SelectionChange (ByVal Target As Range)

End Sub

CodePudding user response:

Feel not understand what mean!