السلام عليكم
لقد وجدت مساعدة كبيرة في منتدانا الغالي وخاصة من كبار أساتذتنا
ولهذا ألجأإليكم في كل مرة لمساعدة
وجدت هذا الكود في أحد برامج الزملاء وفد أعجبني وأريد تطبيقه في برنامجي ولكن لم أنجح
لذا أرجو منكم المساعدة
Sub Rappel_eleves()
On Error Resume Next
Dim MyRange As Range, MyR As Range
Dim r As Integer, N As Integer, M As Integer, MM As Integer, K As Integer, C As Integer, CC As Integer
TT = Application.WorksheetFunction.Match(Range("l2"), Feuil3.Rows("5:5"), 0)
Dim Tab1(8) As Integer
Tab1(1) = TT: Tab1(2) = TT + 1: Tab1(3) = IIf(TT >= 38, "", TT + 2): Tab1(4) = IIf(TT >= 38, TT + 2, TT + 3): _
Tab1(5) = IIf(TT >= 38, TT + 3, TT + 4): Tab1(6) = IIf(TT >= 38, TT + 4, TT + 5): Tab1(7) = IIf(TT >= 38, TT + 5, TT + 6): _
Tab1(8) = IIf(TT >= 38, TT + 6, TT + 7)
Set MyRange = Range("bas_t" & Range("V1"))
kh2_Clears
Application.Calculation = xlCalculationManual
'ÚÏÏ ÇáÓØæÑ ÇáÎÇÑÌÉ Úä äØÇÞ ÇáÇÓÊÏÚÇÁ
N = 7
Application.ScreenUpdating = False
With MyRange
For r = 1 To .Rows.Count
If .Cells(r, 1) = "" Then GoTo 1
If .Cells(r, 6) = Range("d4") Then
M = M + 1
MM = N + M
With Cells(MM, 2)
.Value = M
.AddComment
.Comment.Text Text:="" & r
End With
For K = 1 To 12
C = Choose(K, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
CC = Choose(K, 2, 3, 8, Tab1(1), Tab1(2), Tab1(3), Tab1(4), Tab1(5), Tab1(6), Tab1(8))
If CC = 0 Then Else Cells(MM, C) = .Cells(r, CC)
Next K
End If
1 Next r
End With
'ÊÓØíÑ ÇáÕÝæÝ ÇáãÍÊæíÉ Úáì ÇáÈíÇäÇÊ
With Range("B8:n" & MM)
.Borders.LineStyle = 2
End With
With Range("B8:n" & MM).Font
.Name = "Arial"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
Application.ScreenUpdating = True
Range("g8").Activate
MsgBox "Êã ÇáÇÓÊÏÚÇÁ ÈäÌÇÍ", vbMsgBoxRight, "ÇáÍãÏááå"
On Error GoTo 0
Application.Calculation = xlCalculationAutomatic
End Sub
Sub Rappel.rar