Hi all,

Think this should be quite simple for some the guru's here :D

What I have is this

A B C D E
1 X
2 Y Y Y
3 Y Y Y
4 Z
5 M M M

I need the macro to insert a row between A3 and A4 so that the sheet
will look like this when run
A B C D E
1 (blank row)
2 X
3 Y Y Y
4 Y Y Y
5 (blank row)
6 Z
7 M M M

Thanks


--
stanleysi
------------------------------------------------------------------------
stanleysi's Profile: http://www.excelforum.com/member.php...fo&userid=8893
View this thread: http://www.excelforum.com/showthread...hreadid=544969