combining or statements into one statement

**elmasguapo** · 10-11-2015, 02:51 PM

Is there a way to combine the or statements below?

Please Login or Register  to view this content.

**Richard Buttrey** · 10-11-2015, 03:10 PM

Hi,

Not entirely sure what you mean. Those 'statements' are in fact a single statement, you've just wrapped them onto other rows. There's no reason why you couldn't remove the " _" line break editor symbol.

**jindon** · 10-11-2015, 04:32 PM

I wouldn't do like this though...
1) Add following lines before the loop

Please Login or Register  to view this content.

then

Please Login or Register  to view this content.

or
2) no case-sensitive...

Please Login or Register  to view this content.

**elmasguapo** · 10-12-2015, 02:32 AM

@ Mr Buttrey, I was just curiuos if there was a more effecient way to write the code instead of repeating the or's.

@ Mr. Jindon. The looks a little more efficient but it will take me a bit to interpret it haha. I'll get back. Thanks!!

combining or statements into one statement

LinkBack

Thread Tools

Rate This Thread

Display

combining or statements into one statement

Re: combining or statements into one statement

Re: combining or statements into one statement

Re: combining or statements into one statement

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Combining IF, OR, AND statements together

[SOLVED] Combining four IF statements

[SOLVED] Combining IF Statements

Combining two IF statements into one IF statement

Combining Or Statements (or If Any Statement)

VBA help combining if statements

Combining two IF statements

Bookmarks

Bookmarks

Posting Permissions