Compilation error in VBA

Question

Goodmorning from Holland,

I'm just n00bing around VBA, and keep bumping in to said compilation error as seen in this screenshot; I would like to see this solved, but i want to learn how to kill these horrible errors. What is my mistake?

Just count your Ifs and your End Ifs and you will see it. — Fratyx
– Fratyx, Commented Dec 2, 2015 at 10:30

Verzweifler · Accepted Answer · 2015-12-02 10:30:26Z

2

As the error message is telling you, you are missing one End If-Statement: You are opening three If-Cases, but close only two of them. (I guess you want to put the missing one before the line saying If not Rng Is Nothing Then, thus closing the statement If Trim(FindString) <> "" Then)

For the future: Proper indentation of your code will help you spot errors like this easily!

answered Dec 2, 2015 at 10:30

Verzweifler

9406 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

RobExcel Over a year ago

Thanks for making the way to think about indentation clear to me. Second good answer on one of my questions, hero.

Verzweifler Over a year ago

@RobExcel you're welcome :-) One more thing: Please try to add Code in writing rather than as screenshot. This makes it easier for us to try around with it without having to type everything from scratch!

MaxD · Accepted Answer · 2015-12-02 10:30:24Z

2

Your "If Not Rng Is Nothing Then" is missing an "End If"

It should be more obvious if you indent correctly your code.

answered Dec 2, 2015 at 10:30

MaxD

3772 gold badges4 silver badges14 bronze badges

Collectives™ on Stack Overflow

Compilation error in VBA

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related