Insert Cell

bksmith101 · Jul 9th 2004

Is there a way to insert a blank cell?

Thanks

Jong · Jul 9th 2004

you can only insert a row or a column

if you insert a cell, it will basically just add a row or column.

bksmith101 · Jul 9th 2004

thank you for the quick reply!! if you see my other post about deleting cells, you will see the problem I am having.

Anonymous · Jul 9th 2004

The following recorded macro inserts a single cell and then shifts the original cells right or down.

Code

Sub Macro1()
    Range("C9").Select
    Selection.Insert Shift:=xlDown
    Range("D6").Select
    Selection.Insert Shift:=xlToRight
End Sub

Participate now!