From tinkering around with the code produced by the macro recorder,
something like this seems to work:

Range("a1:a5").EntireRow.Insert

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"blazzae" wrote in
message ...

Hi all,

If the Syntax to insert 1 row is ( macro) :

Selection.EntireRow.Insert

Then what is the correct Syntax to insert more than 1 row ?
Let's say there were 5 rows.

I though it would be:

Selection.EntireRow.Insert,5)

Thankyou.


--
blazzae
------------------------------------------------------------------------
blazzae's Profile:
http://www.excelforum.com/member.php...o&userid=24981
View this thread: http://www.excelforum.com/showthread...hreadid=385147