haystack
here is a macro that will insert 5 blank lines after every row
something similar can be done to insert formulas as required or to copy
a range and paste it into the blank rows
--
mudraker
------------------------------------------------------------------------
mudraker's Profile:
http://www.excelforum.com/member.php...fo&userid=2473
View this thread:
http://www.excelforum.com/showthread...hreadid=535761