Thank you Gord, Ron's Macro is working fine.

"Gord Dibben" wrote:

Do you really need the blanks rows?

If so, go with Ron's solution.

If just for appearance, select all rows and double the height.


Gord Dibben Excel MVP

On Sat, 8 Oct 2005 04:29:03 -0700, "Pradeep Patel"
wrote:

Hi,

I have requirements for inserting a blank row in-between existing rows. So I
have let say 300 rows with data and I want to insert a blank row after each
exisitng data row. Is there anything available in Excel? or I have no option
but to manually inserting each row. Please help!!!

Thank you