Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greeings. I apologize if this is a double post, but my first attempt does
not seem to have shown up. I need to cut the active row from the active sheet, and paste it into the first blank row on another sheet. So far, this is what I have. I could do it by selecting the target sheet and row, but I would like to avoid moving from the active sheet if possible. Thank you. Sub Test() Dim WS As Worksheet Dim LastRow As Integer 'Cut the active row from the active sheet ActiveCell.EntireRow.Cut 'Set the target sheet Set WS = ActiveWorkbook.Sheets!held 'Set start row of the destination sheet LastRow = 8 With WS 'Get the first blank row on destination sheet For i = 8 To 300 Step 1 If Len(.Cells(i, 4).Value & "") 0 Then LastRow = LastRow + 1 End If Next i 'Need to paste the row that was cut from the previous sheet .Range("A" & LastRow).Paste End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
loop through the workbook and paste every sheet it into newly createdworkbook with same sheet name | Excel Programming | |||
Line count in sheet determines paste range in another sheet | Excel Programming | |||
Line count in 1 sheet to determine paste range in 2nd sheet. | Excel Programming | |||
Copy Paste from Class Sheet to Filtered List on Combined Sheet | Excel Programming | |||
Help to code Macro to Copy fron one sheet and paste in other sheet | Excel Programming |