Selection ?
30.07.2007 10:18:32
Andrea
wie kann ich bei folgendem aufgezeichneten Code das SELECT rauslassen?
' Range("I50,K50,M50,N50").Select
' Range("N50").Activate
' Selection.Borders(xlDiagonalDown).LineStyle = xlNone
' Selection.Borders(xlDiagonalUp).LineStyle = xlNone
' Selection.Borders(xlEdgeLeft).LineStyle = xlNone
' With Selection.Borders(xlEdgeTop)
' .LineStyle = xlContinuous
' .Weight = xlThin
' .ColorIndex = xlAutomatic
' End With
' With Selection.Borders(xlEdgeBottom)
' .LineStyle = xlDouble
' .Weight = xlThick
' .ColorIndex = xlAutomatic
' End With
' Selection.Borders(xlEdgeRight).LineStyle = xlNone
' Rows("50:50").Select
' Selection.RowHeight = 16
' Selection.Font.Bold = True
vielen Dank für Eure Mühe
Gruss Andrea