Insert Row using Macro

[naruale]

Hey there!! I have just joined this forum. I hope you guys may be able to help me. Heres my question.

I hav a macro to insert a new row. But i also want the macro to ask the user to input where he wants(which row number) to insert the new row??

For example when i run the macro, an inputbox should come up asking to input the row number. The user should be able to enter the row number (take 10 for now). And Excel should automatically insert a new row in row number 10. So the previous row 10 now becomes row 11.

 

[naruale]

Thank you so much sir. It Works.

 

[naruale]

Dear Sirs,
For now, the User can input only 1 row number to delete it. Is there any way we can input multi row numbers at the same time when Excel asks to input it.

When inputing multi row numbers, user should be able to enter it in different formats.
1st method: 1,2,3,4,5
2nd method: A1:A5