insert blank rows

[naflas]

anybody tell me how to insert blank rows between rows.

I have 25000 rows,need to be spilit as attached

[pike]

Hi naflas
A quick search of the forum found this by jb

Please Login or Register  to view this content.

[naflas]

Hi Guys,

I want to send excel sheet via email to all my staff members to write their latest address.
Are there any possibilities to get the latest address to my copy once they have entered in the excl sheet?

[pike]

naflas
I dont understand doesn't the code add extra rows between the rows to add there address?