Now I'm getting a "Object Variable or With Block Variable Not Set"
Could it have something to do with the ", ," within the find function?
the Code below is what I'm trying to Run
![]()
Sub LookCopyCleanTest() With Sheets("Daily Report").Cells(6, 3) Sheets("Production Data - 09").Columns(1).Find(.Value, , xlValues, xlWhole).Offset(, 1) = .Cells(30, 5).Value End With End Sub
Bookmarks