Insert row

  • Thread starter RE: VLOOKUP fORMULA
  • Start date
R

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
 
A

AltaEgo

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

Selection.EntireRow.Insert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top