| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding Rows and copying cells
I'm a new Excel user. I'm trying to insert a row and copy a cell to the cell
directly below it. This happens at various locations through the sheet so I need it to Paste directly below labeled cell. CALC is the labeled Column and INROWB1 is the labeled Row Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove Range("CALC INROWB1").Select Selection.Copy Range("CALC INROWB1+1").Select ActiveSheet.Paste There has obvously got to be an better way than this... any ideas. thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked sheets, blank cells and adding new rows | Excel Worksheet Functions | |||
| Need help copying cells into rows with spaces between | Excel Discussion (Misc queries) | |||
| How do I turn 1 cell into 2 cells without adding columns or rows? | Excel Discussion (Misc queries) | |||
| Copying cells from varying rows | Excel Discussion (Misc queries) | |||
| Adding a subset of rows of cells, SUM, based on Lookup | Excel Discussion (Misc queries) | |||
Threaded Mode
