| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying a row to new worksheet
I've copied some information - actually filtered data - from a source
worksheet (src or "ACTIVE"). Below I write that to a newly created destination worksheet (dst). Afterwards I need to copy a row with header information from src to dst. However when I to this, Row 2 in dst disappears. (dst appear with row 1 and then row 3.) What am I doing wrong? Set dst_sheet = Worksheets.Add ActiveSheet.Paste Selection.Columns.AutoFit dst_sheet.Activate Range("a2").Select Selection.EntireRow.Insert Sheets("ACTIVE").Range("a2").EntireRow.Copy dst_sheet.Paste Destination:=dst_sheet.Cells(2, 1) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet formula incorrect after copying to another worksheet | Excel Worksheet Functions | |||
| Copying the active worksheet to another worksheet in the same work | Excel Worksheet Functions | |||
| Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
| Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
| Copying Worksheet triggers Click event of combobox on another worksheet | Excel Programming | |||
Threaded Mode
