Hi JVR,

Go to http://www.andrewsexceltips.com/my_utilities.htm and download the
utillities. I got this tip this week from this discussion group and it is
very helpful and it is free! When it is installed on your computer, just go
to the Andrew's Utilities tool bar, then to the "sheet utilities" and select
"show selection tools". There are many functions that can do the work! and
much more.

JS

"JVR" wrote:

I want to insert rows after every 5 cells in a excel file that has data of
120 rows. I dont want to start inserting every single time. Is there a
function to insert a rows in a file at an interval?