convert the if conditions to OR conditions

Hello everybody,

I have the following if conditions which I have to convert into OR statements in a simple way. That is, if either one of this condition is true then the variable count should be updated (count =count +1)

Please Login or Register  to view this content.

Thank you
Vijay

Hi Vijay
Try this:

Please Login or Register  to view this content.

@MarvinP, I've not looked at the question but noticed a couple of possible corrections / modifications ?

Please Login or Register  to view this content.

in the above Rows.Count should also be qualified (per Cells)

Please Login or Register  to view this content.

would probably be better written as

Please Login or Register  to view this content.

this way if the Column Array is modified the subsequent iteration will adapt accordingly (given the Split you could persist with 0 if preferred)

DO,

So you're saying I needed
With WkSht
LastRow = .Cells(.Rows.Count, "B").End(xlUp).Row
Where I needed a period before the Rows.Count? This has plagued me for the last few months.

Also - In the need for Split( ) to get values into an array. Isn't there an easier way? Can't I somehow just declare an Array with values of numbers? Like MyArray = {2,3,4,5} ?

My mistake! Also beware of the period in front of Rows.Count in the LastRow = statement.

I guess part of my signature line of "One Test is worth a Thousand Opinions" means testing is needed to insure thing work correctly.

Sorry. I hope you can use my close-code and get it to work for you.

Originally Posted by nynamyna

What should I do for that type mismatch error ?

Originally Posted by MarvinP

Also - In the need for Split( ) to get values into an array. Isn't there an easier way? Can't I somehow just declare an Array with values of numbers? Like MyArray = {2,3,4,5} ?

To kill 2 birds with one stone:

Please Login or Register  to view this content.

In the most general of terms to assign multiple values to an array simultaneously requires the Array be of Variant type (as opposed to Long for ex.)

Again - I've not actually looked at the code in relation to the question itself.

Here is the revised code.
I need to learn and then OWN the Stuff = Array( Other Stuff).. Thanks DO.

Please Login or Register  to view this content.

I have no idea what you are counting in this code but the above example should give you some ideas. Funny stuff is that Arrays first member is the zero guy. So in above ColArray(0) = 2. The 2 is the column of "B".
I've also corrected the above with the period before Rows in the LastRow line.

hope this gets you what you want from your first try at code above.