Sub Rectangle1_E()
Dim sArr(), eRow&, fRow&, sRow&, i&, strRes$
With Sheets("D")
eRow = .Range("B" & Rows.Count).End(xlUp).Row
If eRow < 5 Then MsgBox ("Khong co du lieu"): Exit Sub
sArr = .Range("C6:K" & eRow).Value
End With
sRow = UBound(sArr)
On Error Resume Next
fRow = Range("B2").Value
If fRow < 1 Then fRow = 1
eRow = Range("C2").Value
If eRow > sRow Then eRow = sRow
For i = fRow To eRow
Range("D5").Value = sArr(i, 1)
Range("E6").Value = sArr(i, 4)
Range("F6").Value = sArr(i, 5)
Range("E7").Value = sArr(i, 6)
Range("F7").Value = sArr(i, 7)
Range("E8").Value = sArr(i, 8)
Range("F8").Value = sArr(i, 9)
Range("D2:F15").PrintPreview ' Xem truoc khi in
'Range("D2:F15").PrintOut 'In
strRes = strRes & "," & i
Next i
If Len(strRes) Then
MsgBox ("Da in cac So thu tu: " & Mid(strRes, 2, Len(strRes)))
Else
MsgBox ("Du lieu So Thu Tu khong phu hop, Khong In")
End If
End Sub
Sub Rectangle2_E()
Dim sArr(), S, eRow&, N, sRow&, i&, ik&, strRes$
With Sheets("D")
eRow = .Range("B" & Rows.Count).End(xlUp).Row
If eRow < 5 Then MsgBox ("Khong co du lieu"): Exit Sub
sArr = .Range("C6:k" & eRow).Value
End With
sRow = UBound(sArr)
On Error Resume Next
strRes = Range("B4").Value
S = Split("," & strRes, ",")
strRes = ""
N = UBound(S)
For i = 1 To N
If IsNumeric(S(i)) Then
ik = CLng(S(i))
If ik > 0 And ik <= sRow Then
Range("D5").Value = sArr(ik, 1)
Range("E6").Value = sArr(ik, 4)
Range("F6").Value = sArr(ik, 5)
Range("E7").Value = sArr(ik, 6)
Range("F7").Value = sArr(ik, 7)
Range("E8").Value = sArr(ik, 8)
Range("F8").Value = sArr(ik, 9)
Range("D2:F15").PrintPreview ' Xem truoc khi in
'Range("D2:F15").PrintOut 'In
strRes = strRes & "," & ik
End If
End If
Next i
If Len(strRes) Then
MsgBox ("Da in cac So thu tu: " & Mid(strRes, 2, Len(strRes)))
Else
MsgBox ("Du lieu So Thu Tu khong phu hop, Khong In")
End If
End Sub