In the attached,
Net Rate Sheet 2.DeleteThem should remove anything on Net Rate sheet 2 between the service name and the phrases
If .Cells(lngend, 1) = "Please refer to list rates for this service." Or _
.Cells(lngend, 1) = "Net Rates are not available for these services" Then
However, it is not working for the service "Domestic First Overnight Non-Freight"
Can someone help?