HELP needed at insert a number of rows!

[alfa_eng]

Hi guys!

I have a problem! I have a cell with a number and I need to insert in a table that number of rows. If I have 5, I want to tell excel to introduce 5 rows, if I have 2 I want to tell excel to introduce 2. How can I do that with VBA and Excel? For example:

	A	B	C	D	E	F	G	H	I
1	number of rows	5
2
3	number of the row	x	y	x,y
4	1	0	4	0,4
5	2	10	36	10,36
6	3	19	74	19,74
7	4	47	12	47,12
8	5	35	69	35,69
9

<tbody>
</tbody>

Can anyone help me??
Thank you!

 

[LloydFinancials]

Hi, See if this works.

Sub MyInsertRows1()
    
    Application.DisplayAlerts = False
    
    Dim i As Integer
    
    For i = 1 To Range("B1").Value
        Rows(4).Insert
    Next i
    
    Application.DisplayAlerts = True

End Sub

Luke