Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Code works fine....
Just want to ammend code to paste on next available row on "Data" sheet. ....starting in column A. Sub ABC() 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 rw = 2 Set sh = Worksheets("Data") For Each cell In c If Application.CountIf(i, cell) 0 Then Range(cell, Cells(cell.Row, "G")).Copy sh.Cells(rw, 1) rw = rw + 1 End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code to copy and paste those cells that have data | Excel Programming | |||
Code to copy and paste those cells that have data | 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 | |||
Got the Copy/Cut Code But what is the Paste Code | Excel Programming | |||
VBA code gets lost from workbook if I paste in new data and save??? | Excel Programming |