Tự động tô màu hàng, cột khi click chuột vào ô trong Excel

byĐỗ Quang Dũng 0 تعليقات

 Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next
Cells.Interior.ColorIndex = 0
ActiveCell.EntireRow.Interior.ColorIndex = 8
ActiveCell.EntireColumn.Interior.ColorIndex = 8
Application.CutCopyMode = True
End Sub

Tags
أحدث أقدم

Comments

Responsive Advertisement