inserting a row on an excel sheet 1

[kenguru]

Hello,

Can anyone point me out how can i insert a row in an excel sheet? I recorded a macro, and it gave me:
Sheets("ABC").Select
Rows("22:22").Select
Selection.Insert Shift:=xlDown

Isn't a simpel way, or more general way of doing it?

Thank you,
Kenguru

 

[SkipVought]

Hi,

I recommend using the Insert and Delete methods as little as possible. You might try appending a row to the bottom of your table and then sorting the table to achieve what the Insert would have done.

However, if you need to insert a row...

Sheets("ABC").Cells(22,1).entirerow.Insert Shift:=xlDown

Skip,

_[red][/red]