Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The second bottom half of this code is supposed to paste the range to
the sheet "data" (A:F) on the next available row. It worked once somehow but, I can't get past the error on this line now. Range(cell, Cells(cell.Row, "g")).Copy sh.Cells(NewRow, 1) Sub ABC2() Dim cell As Range, c As Range Dim i As Range, rw As Long Dim sh As Worksheet With Worksheets("List") Set c = .Range(.Cells(6, "B"), .Cells(6, "B").End(xlDown)) Set i = .Range(.Cells(6, "I"), .Cells(6, "I").End(xlDown)) End With Set sh = Worksheets("Data") LastRow = sh.Cells(Rows.Count, "a").End(xlUp).Row NewRow = LastRow + 1 For Each cell In c If Application.CountIf(i, cell) 0 Then Range(cell, Cells(cell.Row, "g")).Copy sh.Cells(NewRow, 1) NewRow = NewRow + 1 End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA code does not copy and paste to next row for each zip code | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Cut and Paste using Macro gives paste special method error | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming |