AW: On Error wird NICHT ignoriert
15.07.2010 15:10:15
Gregor
Hallo NoNet
Noch so gerne, hier mein Code
Sub Pläne_aktualisieren()
Application.ScreenUpdating = False
Application.EnableEvents = False
Dim Abk As Variant, URL As Variant
Spalte_Abkürzung = Worksheets("Master Datei").Rows(1).Find("Abkürzung", lookAT:=xlWhole).Column
Spalte_Plan = Worksheets("Master Datei").Rows(1).Find("Plan I-B", lookAT:=xlWhole).Column
Worksheets("Master Datei").Activate
intLastRow = Worksheets("Tabelle1").Cells(Rows.Count, 1).End(xlUp).Row
For Start = 1 To intLastRow
Objekt = Worksheets("Tabelle1").Cells(Start, 1).Value
Set rng = Sheets("Master Datei").Range("A:A").Find(Objekt, lookAT:=xlWhole)
If Not rng Is Nothing Then
Zeile = rng.Row
Abk = Sheets("Master Datei").Cells(Zeile, Spalte_Abkürzung).Value
On Error GoTo weiter
' On Error Resume Next
Sheets("Master Datei").Shapes("Plan" & Abk).Select
'---Hyperlink zuteilen
URL = Sheets("Tabelle1").Cells(Start, 3).Value
ActiveSheet.Hyperlinks.Add Anchor:=Selection.ShapeRange.Item(1), Address:=URL
GoTo weiter1
weiter:
'---wenn neu
ActiveSheet.Shapes("Plan").Copy
Cells(Zeile, Spalte_Plan).Select
ActiveSheet.Paste
With Selection.ShapeRange
.Name = "Plan" & Abk
End With
ActiveSheet.Shapes("Plan" & Abk).Select
'---Hyperlink zuteilen
URL = Sheets("Tabelle1").Cells(Start, 3).Value
ActiveSheet.Hyperlinks.Add Anchor:=Selection.ShapeRange.Item(1), Address:=URL
End If
weiter1:
Next
Application.ScreenUpdating = True
Application.EnableEvents = True
End Sub
Danke und Gruss
Gregor