Sub 提取需要的药品()
'.............
With Sheets(myName)
Sheets("原始数据").Cells.Copy .Cells(1, 1)
.Cells.ClearContents
.Columns("A:A").NumberFormatLocal = "@"
.Range("a1").Resize(n, UBound(drr, 2)) = drr
.Rows(Range("A65536").End(3).Row + 1 & ":" & 65536).Delete
End With
End Sub