AW: mit Array
26.10.2010 20:32:10
hary
Hallo Nico
so koennen die betr. Tabelle stehen wo sie wollen.
Sub n()
Dim blaetter, wks As Worksheet, n As Integer
Dim ZELLE As Range
Application.ScreenUpdating = False
blaetter = Array("932V", "933V", "923V", "954V", "932P", "933P", "923P", "954P", "959P")
For Each wks In Worksheets
For n = 0 To UBound(blaetter)
If blaetter(n) = wks.Name Then
With wks.Range("A8:A19")
Set ZELLE = .Find(Sheets("START").Range("F6").Value, LookIn:=xlValues, lookat:= _
xlWhole)
If Not ZELLE Is Nothing Then
ZELLE.Offset(0, 3) = ZELLE.Offset(0, 3)
ZELLE.Offset(0, 7) = ZELLE.Offset(0, 7)
ZELLE.Offset(0, 11) = ZELLE.Offset(0, 11)
ZELLE.Offset(0, 15) = ZELLE.Offset(0, 15)
ZELLE.Offset(0, 19) = ZELLE.Offset(0, 19)
End If
End With
End If
Next n
Next wks
Set Zelle = nothing
Application.ScreenUpdating = True
End Sub
gruss hary