Other suggestion :
Sub Button3_Click()
Dim CustomerName
Dim WkRow
Dim Test As Boolean
CustomerName = Range("A59")
WkRow = Evaluate("=MATCH(""" & CustomerName & """,Sheet1!$A:$A,0)")
Test = Application.WorksheetFunction.IsNumber(WkRow)
If (Test) Then
Rows(59 & ":" & 59).Copy
With Sheets("Sheet1")
.Rows(WkRow & ":" & WkRow).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End With
Else
Rows(59 & ":" & 59).Copy
With Sheets("Sheet1")
.Range("A" & .Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End With
End If
End Sub
Bookmarks