Can someone explain to me why my Excel 2003 is not recognizing ( If )?
I've tried several codes with the If function and my code won't run.
If (this or that) Then...

and

If (this or that) Then....
Elseif (this or that) Then......
End If

In the first case the debugger says (End If without a block If).

In the second case the debugger says (ElseIf without a block If).

hi
usually means what it says. but we are not going to know untill you post
your code.

regards
FSt1

"chrisnsmith" wrote:

Can someone explain to me why my Excel 2003 is not recognizing ( If )?
I've tried several codes with the If function and my code won't run.
If (this or that) Then...

and

If (this or that) Then....
Elseif (this or that) Then......
End If

In the first case the debugger says (End If without a block If).

In the second case the debugger says (ElseIf without a block If).

Post your ACTUAL code, not that pseudo-code... it is very hard to debug code
when you can't see the code.

--
Rick (MVP - Excel)


"chrisnsmith" wrote in message
...
Can someone explain to me why my Excel 2003 is not recognizing ( If )?
I've tried several codes with the If function and my code won't run.
If (this or that) Then...

and

If (this or that) Then....
Elseif (this or that) Then......
End If

In the first case the debugger says (End If without a block If).

In the second case the debugger says (ElseIf without a block If).

Post the code that fails.


Gord Dibben MS Excel MVP

On Fri, 6 Feb 2009 12:33:01 -0800, chrisnsmith
wrote:

Can someone explain to me why my Excel 2003 is not recognizing ( If )?
I've tried several codes with the If function and my code won't run.
If (this or that) Then...

and

If (this or that) Then....
Elseif (this or that) Then......
End If

In the first case the debugger says (End If without a block If).

In the second case the debugger says (ElseIf without a block If).

I suspect the full code looks something like this:

If x = 1 or x=2 then y = 3
ElseIf x = 4 or x = 5 then y = 6
End if

If so, it should be

If x = 1 or x=2 then
y = 3
ElseIf x = 4 or x = 5 then
y = 6
End if

Incidentally, there is no need in VB/VBA to enclose the
conditions in parentheses; IMHO it needlessly clutters
up the code.




On 6 Feb, 20:33, chrisnsmith
wrote:
Can someone explain to me why my Excel 2003 is not recognizing ( If )?
I've tried several codes with the If function and my code won't run.
If (this or that) Then...

and

If (this or that) Then....
Elseif (this or that) Then......
End If

In the first case the debugger says (End If without a block If).

In the second case the debugger says (ElseIf without a block If).

You must be familiar with the usual VB codes to be able to use macros.
As you are facing a problem related to conditional statement, I will describe briefly about its syntax

If you are just using one if statement then the syntax would be like
IF condition1 then
<statements
………………………
End If

Now if you are using nested If-Else structure then the syntax would be like
IF condition1 then
<statements
………………….
ElseIF condition2 then
|<statements
……………………..
End IF


Hope you get it.....


Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com