| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cut and pasting a row in another workbook on the next available l.
I want to record a macro which cuts a row from a sheet and pastes the row
into another sheet without deleting any existing rows. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cut and pasting a row in another workbook on the next available l.
Something like this will do the trick:-
ActiveCell.EntireRow.Select Selection.Cut Sheets("Sheet2").Select Range("a65535").End(xlUp).Offset(1, 0).Select ActiveSheet.Paste "stressed" wrote: I want to record a macro which cuts a row from a sheet and pastes the row into another sheet without deleting any existing rows. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cut and pasting a row in another workbook on the next available l.
stressed
Sub Copyit() Sheets("Sheet1").Range("1:1").Copy Destination:= _ Sheets("Sheet2").Cells(Rows.Count, 1).End(xlUp) _ .Offset(1, 0) End Sub Note: you could use Activesheet instead of Sheets("Sheet1") to make it more generic. Gord Dibben Excel MVP On Mon, 29 Aug 2005 13:50:44 -0700, "stressed" wrote: I want to record a macro which cuts a row from a sheet and pastes the row into another sheet without deleting any existing rows. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and Pasting to Another Workbook | Excel Discussion (Misc queries) | |||
| Pasting Data from One Workbook to Another | Excel Worksheet Functions | |||
| Disable Pasting into a Workbook | Excel Worksheet Functions | |||
| pasting from one excel workbook to another | Excel Worksheet Functions | |||
| Pasting from a specific Workbook to another workbook without having to name it. | Excel Programming | |||
Linear Mode
