floridagunner
MIS
I need a unique Macro for Excel and I cant seem to find the solution in VBA Help.
Basically what I need to do is reference a cell and automatically insert a number of rows according to the number in the cell.
EG
Column R
5
1
2
6
8
4
3
This means if cell R1 contains the number (5) I need a macro that will insert 4 rows below that cell. If R2 contains the number 2, the macro should insert 1 row below that cell.
Any help is greatly appreciated.
Thanks
Basically what I need to do is reference a cell and automatically insert a number of rows according to the number in the cell.
EG
Column R
5
1
2
6
8
4
3
This means if cell R1 contains the number (5) I need a macro that will insert 4 rows below that cell. If R2 contains the number 2, the macro should insert 1 row below that cell.
Any help is greatly appreciated.
Thanks