VBA-Problem....
06.09.2004 13:31:59
Stefan
Thx
Stefan
Sub farben_test()
Set ws = Worksheets("Sheet1")
With Worksheets("Sheet1")
For i = 1 To .Cells(65535, 4).End(xlUp).Row
Select Case Cells(i, 4)
Case Cells(i, 4).Font.ColorIndex = 9
Cells(i, 4).Copy Destination:=ws.Cells(i, 1)
Case Cells(i, 4).Font.ColorIndex = 10
Cells(i, 4).Copy Destination:=ws.Cells(i, 2)
Case Cells(i, 4).Font.ColorIndex = 11
Cells(i, 4).Copy Destination:=ws.Cells(i, 3)
End Select
Next i
End With
Set ws = Nothing
End Sub