You guys had previously helped me write a macro which worked at the time. Now when I run the macro, I receive an error: "Run-Time Error '1004': Application-Defined or Object-Defined Error" The following is the macro:
Sub x()
Dim r As Range
Dim cell As Range
Set r = Worksheets("Data").UsedRange
With r.Resize(, 1).Offset(, r.Columns.Count)
.FormulaR1C1 = "=counta(rc12:rc13)*counta(rc15:rc16)"
For Each cell In .Cells
If cell.Value Then
Intersect(cell.EntireRow, r.EntireColumn).Copy _
Destination:=Worksheets("RF#MTC#Match").Cells(Rows.Count, "A").End(xlUp).Offset(1)
End If
Next cell
.ClearContents
End With
End Sub
If I click "Debug", the line "With r.Resize(,1)....... becomes highlighted in yellow. I don't anything about Basic. I would appreciate any help you can provide.
Thanks!
Bookmarks