![]() |
|
#1
|
|||
|
|||
![]()
Here are two attempts that failed :
Code:
Sub Names() Dim Cell As Range Dim NextRow As Variant Dim lrA As Long ', lrD As Long Dim i As Long, j As Long, x As Long Application.ScreenUpdating = False lrA = Range("K" & Rows.Count).End(xlUp).Row NextRow = Sheet3.Cells(Rows.Count, 1).End(xlUp).Row + 1 For i = 7 To lrA If Range("K" & i).Resize("N" & i).Value = "0.00" Then Range("K" & i).EntireRow.Copy Destination:=NextRow End If i = i + 1 Next i Application.ScreenUpdating = True 'MsgBox "completed" End Sub Sub copy_rows() Dim i As Long i = Sheet1.Range("A" & Rows.Count).End(xlUp).Row For i = 7 To i If Cells(i, 11) = "0.00" And Cells(i, 12) = "0.00" And Cells(i, 13) = "0.00" And Cells(i, 14) = "0.00" Then Cells(i, 11).EntireRow.Copy Sheet3.Cells(Rows.Count, 1).End(xlUp).Row + 1 End If Next i End Sub |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
VBA Code to copy data from two sheet ,paste into corresponding sheet through cmdbutton | jackfruit88 | Excel Programming | 1 | 07-08-2022 09:27 PM |
copy paste of pst sees address book empty , why ? | DBenz | Outlook | 1 | 05-30-2019 10:21 PM |
copy a row and paste the row into another sheet more then one time:macro | waqar1239 | Excel Programming | 1 | 04-07-2017 09:57 AM |
![]() |
cloudforgiven | Excel Programming | 6 | 01-05-2017 07:30 PM |
copy checkbox string and paste it in excel sheet | MOHAMMEDSALMAN | Excel Programming | 7 | 10-29-2015 03:50 AM |