bạn kiểm tra lại hộp thư của mình nhé
HI BẠN
BẠN XEM GIÚP MÌNH, MÌNH SỬA LẠI ĐỂ COPY SANG FILE CỦA MÌNH MÀ KO CHẠY
Sub TESt1()
Dim Rng As Range, Rng1 As Range
Dim i, j, k As Integer
Dim a, b, c, lastRw
lr = Sheets("DS CAP NHAT").Range("B" & Rows.Count).End(xlUp).Row
check = Sheets("DS CAP NHAT").Range("B7")
If check = "" Then
Else
Set Rng = Sheets("DS CAP NHAT").Range("A7:AV" & lr)
Rng.EntireRow.Delete shift:=xlUp
End If
a = Sheets("DS CAP NHAT").Range("Q1")
b = Sheets("DS CAP NHAT").Range("R1")
lasRw = Sheets("DS KY HD").Range("B" & Rows.Count).End(xlUp).Row
For i = 8 To lasRw
vDate = Sheets("DS KY HD").Cells(i, 13)
c = Sheets("DS CAP NHAT").Cells(Rows.Count, "B").End(xlUp).Row
If c = 5 Then
d = c + 1
Else
d = c
End If
If vDate >= a And vDate <= b Then
For j = 1 To 47
Sheets("DS CAP NHAT").Cells(d + 1, j) = Sheets("DS KY HD").Cells(i, j)
Next j
End If
Next i
lr1 = Sheets("DS CAP NHAT").Range("B" & Rows.Count).End(xlUp).Row
Set Rng1 = Sheets("DS CAP NHAT").Range("A7:AV" & lr1)
Rng1.Select
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlInsideVertical)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlInsideHorizontal)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
End Sub