dear friend.i have got excellent macro from below thread.this macro work fine only the problem is this macro creating rows above the formula cell.but i need to create new rows below the formula cell.pls any can correct it it very big help for me.
http://www.excelforum.com/excel-gene...n-formula.html
Bookmarks