T
Temjeh
Guest
Bonsoir a tous
J'ai simplifié un peu ma question antérieur(sans réponse précise):
J'ai fait ceci mais il me copie a la suite toujours A2:E2 je voudrait si possible que Si If Range("F3") = "N" Then Range("A3:E3").Select.....
Sub Notes_Spéciales()
If Range("F2") = "N" Then
Range("A2:E2").Select
Selection.Copy
Else
If Range("A18") = "" Then
Range("A18").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Else
If Range("A19") = "" Then
Range("A19").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Else
If Range("A20") = "" Then
Range("A20").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Else
If Range("A21") = "" Then
Range("A21").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
If Range("F3") = "N" Then
Range("A3:E3").Select
Selection.Copy
If Range("A18") = "" Then
Range("A18").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Else
If Range("A19") = "" Then
Range("A19").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Else
If Range("A20") = "" Then
Range("A20").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Else
If Range("A21") = "" Then
Range("A21").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
End If
End If
End If
End If
End If
End If
End If
End If
End If
End If
End Sub
Merci de votre aide
J'ai simplifié un peu ma question antérieur(sans réponse précise):
J'ai fait ceci mais il me copie a la suite toujours A2:E2 je voudrait si possible que Si If Range("F3") = "N" Then Range("A3:E3").Select.....
Sub Notes_Spéciales()
If Range("F2") = "N" Then
Range("A2:E2").Select
Selection.Copy
Else
If Range("A18") = "" Then
Range("A18").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Else
If Range("A19") = "" Then
Range("A19").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Else
If Range("A20") = "" Then
Range("A20").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Else
If Range("A21") = "" Then
Range("A21").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
If Range("F3") = "N" Then
Range("A3:E3").Select
Selection.Copy
If Range("A18") = "" Then
Range("A18").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Else
If Range("A19") = "" Then
Range("A19").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Else
If Range("A20") = "" Then
Range("A20").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Else
If Range("A21") = "" Then
Range("A21").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
End If
End If
End If
End If
End If
End If
End If
End If
End If
End If
End Sub
Merci de votre aide