How to simplify lengthy vba code

[soldeerbout]

Hello everybody,

What would be the best way to make code easier to read?

The following code just checks to see if a certain value is between two other values, but it's rather lengthy and difficult to read. If I were to read it a month from now I'd have a hard time trying to figure out what it does (which is where comments get in), but more importantly how it does this.

Please Login or Register  to view this content.

I'm inclined to try to make

Please Login or Register  to view this content.

Into something like 'Object A' etc

So that you get:

Please Login or Register  to view this content.

Is that possible?

I'm not looking to optimize this specific piece of code, it runs fast enough.

The code that I've produced so far is just generally quite lengthy and difficult to read.

Thanks for your time.

[shg]

Welcome to the board.

Please Login or Register  to view this content.

[soldeerbout]

Thanks for your help. My code is a lot more readable now.