schon mal den MakroRekorder benutzt ;o)
02.05.2008 18:44:25
Matthias L
Hallo
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
End With
Oder eben
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlThick
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.Weight = xlThick
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThick
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.Weight = xlThick
End With
Beispiel:
Aus der Hilfe
LineStyle-Eigenschaft
Gibt die des Rahmens zurück oder legt sie fest. Dies kann eine der folgenden XlLineStyle-Konstanten sein: xlContinuous, xlDash, xlDashDot, xlDashDotDot, xlDot, xlDouble, xlSlantDashDot oder xlLineStyleNone. Variant Schreib-Lese-Zugriff.
Ich hoffe zur Lösung Deines Problem's beigetragen zu haben ;o)