I suggest NOT inserting blank rows in you table and simply increase row
heights instead.



--
Regards
Dave Hawley
www.ozgrid.com
"eva cheng" wrote in message
...
Hi,

I am using excel 2003, my file looks like below

order no invoice no amount
123 S1000 $10
234 S1000 $20
456 S1001 $30
123 S1001 $40

I want to use a macro to insert a blank row to separate different invoice
no, how to write it ?

Thanks
eva cheng