Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Am I using the "elseif" like i should?
If Range("A" & i) = "CLS" Then Sheets("CLS").Select ' On sélectionne la Feuille CLS ElseIf Range("A" & i) = "CLU" Then Sheets("CLU").Select ' On sélectionne la Feuille CLU ElseIf Range("A" & i) = "PLC" Then Sheets("PLC").Select ' On sélectionne la Feuille PLC ElseIf Range("A" & i) = "SBCC" Then Sheets("SBCC").Select ' On sélectionne la Feuille SBCC ElseIf Range("A" & i) = "SBCE" Then Sheets("SBCE").Select ' On sélectionne la Feuille SBCE ElseIf Range("A" & i) = "VAG" Then Sheets("VAG").Select ' On sélectionne la Feuille VAG ElseIf Range("A" & i) = "VCL" Then Sheets("VCL").Select ' On sélectionne la Feuille VCL ElseIf Range("A" & i) = "VJR" Then Sheets("VJR").Select ' On sélectionne la Feuille VJR Else Sheets("Principale").Select Range("D1").FormulaR1C1 = "Erreur dans la copie des donnees" End End If thank you for you futur help... Marie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming |