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

Hi,

you inserted two rows in your example, but need to insert one row?

Depending on what condition?

Regards,
Ivan

Hi,

Just to clarify, yes there should be two rows inserted. What the macr
needs to do is to check the values in the 2nd column and if it is "
(empty) then insert a row ABOVE that.

Hope that clarifies

Thanks

Sta

--
stanleys
-----------------------------------------------------------------------
stanleysi's Profile: http://www.excelforum.com/member.php...nfo&userid=889
View this thread: http://www.excelforum.com/showthread.php?threadid=54496

Hi Stan,

Sub InsertRow()
intersect(range("B:B"),activesheet.usedrange).Spec ialCells(xlCellTypeBlanks).entirerow.insert
end sub

Regards,
Ivan