| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Insert Rows Help needed
I have having trouble with the following lines....
Here is what I want it to do : Copy the Row contained in value cRow, and insert a copy of it just below that row. (Only the Formaulas AND Borders, not the vlaues of the cells.) With Worksheets(1) .Rows(cRow + 1).Insert xlShiftDown .Rows(cRow).Copy .Rows(cRow + 1).PasteSpeciaxlPasteFormulasAndNumberFormats End With |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows and copy forumla above it | Excel Discussion (Misc queries) | |||
| Copy/Insert rows | Excel Discussion (Misc queries) | |||
| Copy/Insert rows with formulas | Excel Worksheet Functions | |||
| Copy Rows and insert these rows before a page break | Excel Programming | |||
| Copy insert rows | Excel Programming | |||
Threaded Mode
