شكرا جزيلا
هل يمكن تطبيق هذا الكود :
Sub طبع_محدد()
Dim I As Integer
For I = Range("E1") To Range("F1")
Range("J1") = I
If I <= Range("K1") Then
ActiveSheet.PageSetup.PrintArea = "$B$2:$P$30"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End If
Next I
Range("E1").Select
End Sub
Sub طباعة_ورقة_واحدة()
ActiveSheet.PageSetup.PrintArea = "$B$2:$P$30"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub
Sub طباعة_الكل()
Range("J1").Select
ActiveCell.FormulaR1C1 = "1"
ActiveSheet.PageSetup.PrintArea = "$B$2:$P$30"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Do
ActiveCell = ActiveCell + 2
ActiveWindow.SelectedSheets.PrintOut
Loop Until ActiveCell.Value >= Range("C1").Value
Range("E1").Select
End Sub