一起来学office,提高办公技能 Private Sub Worksheet_Change(ByVal Target As Range) For Each a In UsedRange If a <> "" Then a.Borders.LineStyle = xlContinuous ElseIf a = "" Then a.Borders.LineStyle = xlNone End If Next End Sub |
|
来自: bitterfleabane > 《EXCEL》