End If without block if

[LuisV805]

Hi all,

I'm trying to rub my sub, however, I'm getting a "End if without block if" error and directs me to the below. The if is tens of lines long so I don't want to post the whole thing. This is basically what it looks like:

If InStr(1, ActiveCell.Value, "(", vbTextCompare) Then
<Block of Code>
End If

My first instinct is that I didn't close something in the block of code breaking the connection between the "IF" and "END IF", but I'm new so I want to make sure there's nothing wrong with the first line here (first time using InStr) in an if statement. Can someone confirm the first line was written correctly?

 

[AlphaFrog]

The syntax of your first line is correct.

 

[hiker95]

LuisV805,

What version of Excel and Windows are you using?

I was able to step thru the two lines of code without a problem.

We need to see your entire macro.


When posting VBA code, please use Code Tags - like this:

[code]

Paste your code here.

[/code]

 

[LuisV805]

I got it. I hadn't closed a do loop. Thanks for the help guys!

 

[hiker95]

LuisV805,

Thanks for the feedback.

You are very welcome. Glad you were able to fix the problem.

And, come back anytime.