Selection.EntireRow.Insert question

[Balangan]

Selection.EntireRow.Insert

This command will add an entire row before the selected row. How can I change this command to instead add it below?
(I really need this done this way, no workarounds)

Thanks!

Balangan

[Will Riley]

select the row below the one you've already selected.

i.e. instead of

Range("A4").select
Selection.EntireRow.Insert


use
Range("A4").Offset(1, 0).Select
Selection.EntireRow.Insert

hope this helps

[Andy Pope]

Hi Balangan,

try,

Selection.offset(1,0).EntireRow.Insert

Cheers
Andy

[Balangan]

Originally posted by WillR
select the row below the one you've already selected.

i.e. instead of

Range("A4").select
Selection.EntireRow.Insert


use
Range("A4").Offset(1, 0).Select
Selection.EntireRow.Insert

hope this helps

Hi Willr
that unfortunately wont because the row below has got a different format, and the new row needs to be formatted like the row above. Thanks anyway