AW: Zellbereich kopieren, aber Formeln behalten
03.02.2012 15:06:03
Sascha
Ich habs mal so gelöst:
If Sheets("Hilf").Range("A40") > 0 Then
Sheets("Hilf").Range("A40").Copy
Sheets("LW11").Range("AC3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("B40") > 0 Then
Sheets("Hilf").Range("B40").Copy
Sheets("LW11").Range("AD3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("C40") > 0 Then
Sheets("Hilf").Range("C40").Copy
Sheets("LW11").Range("AE3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("D40") > 0 Then
Sheets("Hilf").Range("D40").Copy
Sheets("LW11").Range("AF3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("E40") > 0 Then
Sheets("Hilf").Range("E40").Copy
Sheets("LW11").Range("AG3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("F40") > 0 Then
Sheets("Hilf").Range("F40").Copy
Sheets("LW11").Range("AH3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("G40") > 0 Then
Sheets("Hilf").Range("G40").Copy
Sheets("LW11").Range("AI3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("H40") > 0 Then
Sheets("Hilf").Range("H40").Copy
Sheets("LW11").Range("AJ3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("I40") > 0 Then
Sheets("Hilf").Range("I40").Copy
Sheets("LW11").Range("AK3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("J40") > 0 Then
Sheets("Hilf").Range("J40").Copy
Sheets("LW11").Range("AL3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("K40") > 0 Then
Sheets("Hilf").Range("K40").Copy
Sheets("LW11").Range("AM3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("L40") > 0 Then
Sheets("Hilf").Range("L40").Copy
Sheets("LW11").Range("AN3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("M40") > 0 Then
Sheets("Hilf").Range("M40").Copy
Sheets("LW11").Range("AO3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("N40") > 0 Then
Sheets("Hilf").Range("N40").Copy
Sheets("LW11").Range("AP3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("O40") > 0 Then
Sheets("Hilf").Range("O40").Copy
Sheets("LW11").Range("AQ3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("P40") > 0 Then
Sheets("Hilf").Range("P40").Copy
Sheets("LW11").Range("AR3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("Q40") > 0 Then
Sheets("Hilf").Range("Q40").Copy
Sheets("LW11").Range("AS3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
If Sheets("Hilf").Range("R40") > 0 Then
Sheets("Hilf").Range("R40").Copy
Sheets("LW11").Range("AT3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End If
Sheets("LW11").Select
Range("A1").Select
End Sub
Kann man diese Aufgabe auch mit einer Schleife lösen? Wenn ja, wie?
LG Sascha