Insert row

[RE: VLOOKUP fORMULA]

Dear Sll, please help me.

Here is a simple macro to insert row in "A13"
Is there any way, when I run a macro to insert the row where I need, or
particular selected cell, for example if i select on A2 and run this macro,
to insert a row in A2

Sub Macro1()

Range("A13").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove

End Sub

Thanks

 

[AltaEgo]

To insert a row at the selected well without needing to select the whole
row:

Selection.EntireRow.Insert

 

[AltaEgo]

Selected well! I should have said "selected cell". Time to take a break!

 

[Don Guillett]

Sub insertrowatselection()
Rows(ActiveCell.Row).Insert
End Sub