一般不主张插入行,
With Tables("表A")
Dim r As Integer r = .FindRow("[公司名称] Like '%湛江%'", .Position + 1, True ) If r >= 0 Then .Position = r + 1
.InsertNew() End IfEnd With