Arun

There have been posted a couple of VBA macros to do what you want.

I'm just wondering why you need the blank rows.

If for appearance only, you could just select the 100 rows and double the
height.

If blank rows are to be used for data input, ignore this suggestion.

Gord Dibben Excel MVP

On Sat, 11 Dec 2004 04:37:02 -0800, "Arun"
wrote:

a workshhet with 30 column 100 rows with data. I would like to insert a
blank row after each row automatically. please help