Posts by dangelor

    Possibly...

    The On Error Resume Next line may be hiding a problem in the called macro...?

    Try this...

    Code
    Sub Copy_Row()
        Dim c As Range
        
        With Workbooks("Sheet1.xlsx").Worksheets("Sheet1")
            Set c = .Rows(4).Find("0f3")
            If Not c Is Nothing Then
                .Range(c.Offset(1), c.Offset(1).End(xlToRight)).Copy Workbooks("Sheet2.xlsx").Worksheets("Sheet2").Cells(10, 11)
            End If
        End With
    End Sub

    Without a workbook to reference, this is my best guess...

    Try...

    Possibly...

    Possibly...

    Possibly...

    Possibly...