-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
else without if
-
V
Else without if Error, but I have an if?
I am getting an else without if error, but I only have one if. Can anyone tell me what I am missing here? If Me.ComboBox1.Value > "" And Me.departure1.Value > "" Then Set myArray = ufd.Range("Truck_1") For z = 1 To i n = 0...- vbaNumpty
- Thread
- else without if vba
- Replies: 1
- Forum: Excel Questions
-
C
else without if error
I'm not sure why I am getting this error message. I thought I had the correct indents, and I also made sure to have a new line after "then" in the if statements. Any suggestions? Here is my code Sub AddMilestone() Set s1 = ThisWorkbook.Worksheets("Release Input") Set s2 =...- chu123456
- Thread
- else without if error if statements indents vba
- Replies: 2
- Forum: Excel Questions
-
S
Compile Error: Else without If
Good morning all, I'm trying to create a calendar on excel. I'm not proficient in VBA at all but I was able to find a youtube video that matched what I wanted to do. I copied the code but now I'm getting this error: Compile Error: Else without If on this part of the code: 'determine what...- SpanishSoul89
- Thread
- compile error else without if vba
- Replies: 7
- Forum: Excel Questions
-
J
Else without If
below is the macro i have but it is coming back with "Else without If" error I'm trying to create a macro that when a cell = USHMTrig then it takes the user to a certain cell on a particular sheet within the worksheet. Sub USHMTrigMac() If L8.Value = USHMTrig Then Do: Sheets("Example -...- JacMeyers
- Thread
- else without if excel vbs
- Replies: 4
- Forum: Excel Questions
-
T
If, ElseIf, Else Statements with Multiple Conditions
Hi All! I have been experiencing this issue in a few macros I've created and don't understand what is wrong with any of the syntax structures I've been experimenting with. When I run the code, it doesn't compile and gives me a message that says "Else without If." From online research, it seems...- torminator111
- Thread
- else without if if then else vba code nested ifs
- Replies: 2
- Forum: Excel Questions
-
Methods to deal with compile error: else without if
Hi There, I am having trouble with finding what is actually wrong with my code in regards to a specific ELSE condition. It highlights the ELSE that is apparently not related to an IF statement. Unfortunately, I am the only one here that has a basic (maybe even very basic because I can't get...- Prevost
- Thread
- compile error else without if error handling
- Replies: 2
- Forum: Excel Questions
-
R
A Compile error: Else without If and I don't know why and how to fix
I'm trying to debug some code and I think the problem area is related to an ElseIf statement. The error message I get is: "Compile error: Else without If" and the row that is highlighed in the Visual Basic viewer is the ElseIf Line. Any help would be appreciated. 'This is option A to add...- Raceman
- Thread
- complie error else without if macro - help
- Replies: 3
- Forum: Excel Questions
-
R
Compile Error: Else without If (after Adding an Internal If Then Statement)
The 2nd else does not attach to the first if, and the Next does not attach to the For Each. How do I correct this? - Thanks, Rowland For Each Cell In acct If Left(Cell, 2) = "43" Then 'change from Left(Cell, 3) = "400" Cell.Font.Bold = True IO = Left(Cell, 9) 'change from IO...- Rowland Hamilton
- Thread
- else without if
- Replies: 4
- Forum: Excel Questions
