Hi All,

Am very new to macros, am trying to write a macros which can :

1. Accept user data to "Enter a number of rows needs to be inserted ?" when they click on "Add Rows button"

2. Rows has to inserted where the cell/full row is highlighted ? macros need to insert say x numbers of blank cells including any formula's exsits.

Can someone help me out with this please..

Many Thanks,
Optimus81