با سلام
لطفا دستورات را بشکل زیر تغییر دهید.
کد:
Private Sub CommandButton4_Click()
On Error Resume Next
Dim c As Range
For Each c In Sheet6.Range("b4:b1000")
For i = 1 To Sheets.Count
If c.Value = Sheets(i).Name Then
Sheets(i).Range("a3:F1000").ClearContents
Range("g4").AutoFilter
Sheet1.Range("$A$4:$G$9").AutoFilter Field:=7, Criteria1:= _
c.Value
Range("A3").Select
Selection.End(xlDown).Select
Range("a5", ActiveCell.Offset(0, 5)).Select
Selection.Copy
Sheets(i).Activate
ActiveSheet.Range("a3").Select
Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
Sheet1.Activate
Range("G4").Select
ActiveSheet.Range("$A$4:$G$9").AutoFilter Field:=7
Exit For
End If
Next i
Next c
End Sub
پایدار باشید میر
علاقه مندی ها (Bookmarks)