Inserting cells in MS Excel 2007

  • Thread starter Thread starter smith06374
  • Start date Start date
S

smith06374

I am trying to select a range of cells (2x50apprx). I need to insert a
blank cell beneath each existing cell (not an entire row) without
having to select each cell individually. I'm sure there is a macro for
this, but I have no idea how to create it. Can someone advise how to
do this?
 
Hi

The below code will insert a cell in column 2 for every row.

For intRow = 1 To 100 Step 2
Cells(intRow + 1, 2).Insert Shift:=xlDown
Next
 
Back
Top