insert cells

[pls123]

hi all !!
i need the vbe command..
for insert the set of cells C80:F80
tx for help!

 

[Gord Dibben]

Macro recorder will give you code.


Gord Dibben MS Excel MVP

 

[JLGWhiz]

The command is:

Range("C80:F80").Insert

If you want to insert complete rows, then:

Range("C80").EntireRow.Insert

Or

Rows(80).Insert

If you want the blank cells to be below row 80 then:

Rows(81).Insert

Because the named row is automatically shifted and the default direction is
down.