| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting cells in MS Excel 2007
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserting cells in MS Excel 2007
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting Rows at Excel 2007 | Excel Discussion (Misc queries) | |||
| vba code for inserting word art using in excel 2007 | Excel Programming | |||
| inserting word art programmatically in excel 2007 | Excel Programming | |||
| Inserting pictures into cells (Excel 2007) | Excel Programming | |||
| Excel 2007 - Error inserting column | Excel Programming | |||
Hybrid Mode
