toandiennuoc123
Thành viên thường trực
- Tham gia
- 7/3/12
- Bài viết
- 239
- Được thích
- 9
Tôi có đoạn code dài quá nó không chạy nhờ các bạn giúp đỡ
Sub Xoa_DL()
Sheets("Dulieu").Range("B5:B180,E5:E180,H5:H180,K5:K180,N5:N180,Q5:Q180,T5:T180,W5:W180,Z5:Z180,AC5:AC180,AF5:AF180,AI5:AI180,AL5:AL180,AO5:AO180,AR5:AR180,AU5:AU180,AX5:AX180,BA5:BA180,BD5:BD180,BG5:BG180,BJ5:BJ180,BM5:BM180,BP5:BP180,BS5:BS180,BV5:BV180,BY5:BY180,CB5:CB180,CE5:CE180,CH5:CH180,CK5:CK180,CN5:CN180,CQ5:CQ180").ClearContents
End Sub
Cám ơn các bạn !
Sub Xoa_DL()
Sheets("Dulieu").Range("B5:B180,E5:E180,H5:H180,K5:K180,N5:N180,Q5:Q180,T5:T180,W5:W180,Z5:Z180,AC5:AC180,AF5:AF180,AI5:AI180,AL5:AL180,AO5:AO180,AR5:AR180,AU5:AU180,AX5:AX180,BA5:BA180,BD5:BD180,BG5:BG180,BJ5:BJ180,BM5:BM180,BP5:BP180,BS5:BS180,BV5:BV180,BY5:BY180,CB5:CB180,CE5:CE180,CH5:CH180,CK5:CK180,CN5:CN180,CQ5:CQ180").ClearContents
End Sub
Cám ơn các bạn !