VBA issue help? lower case vs Upper Case

[FGaxha]

I have a macro ruining on range A2:V7500, looking for two conditional Names" "OES" and "James" and copy data to new tab

If names "OES" or "James" are UPPER case letter, then does not count. Any suggestions please.
--------------
Sub test3()
Dim outarr()
inarr = Range("A1:V7500")
ReDim outarr(1 To 7500, 1 To 22)
indi = 1
For i = 2 To 7500
If inarr(i, 10) = "OES" And inarr(i, 20) = "James" And inarr(i, 22) <= 12 Then
' copy row
For j = 1 To 22
outarr(indi, j) = inarr(i, j)
Next j
indi = indi + 1
End If
Next i
Worksheets.Add
ActiveSheet.Name = "James"
If indi > 1 Then
Range(Cells(1, 1), Cells(indi - 1, 22)) = outarr
End If
End Sub
------

 

[Joe4]

Try:

If UCase(inarr(i, 10)) = "OES" And UCase(inarr(i, 20)) = "JAMES" And inarr(i, 22) <= 12 Then

 

[FGaxha]

Well,
Im looking for either Upper case , Lower Case and combine upper and lower case. Input data are entered by others so sometimes names can be typed differently?

Thanks again.

 

[Joe4]

Well,
Im looking for either Upper case , Lower Case and combine upper and lower case. Input data are entered by others so sometimes names can be typed differently?

Thanks again.

Yes, my code will do that. Did you try it?

The logic is that VBA is converting everything to Upper Case for purposes of testing it.
So:
"oes" becomes "OES"
"Oes" becomes "OES"
"OES" stays "OES"
etc.

By making everything upper case, we can then compare it to "OES".
So we are standardizing it all for the sake of the comparsion to remove the different ways it may be entered.

 

[FGaxha]

Tis is great. thank you

 

[FGaxha]

Yes, my code will do that. Did you try it?

The logic is that VBA is converting everything to Upper Case for purposes of testing it.
So:
"oes" becomes "OES"
"Oes" becomes "OES"
"OES" stays "OES"
etc.

By making everything upper case, we can then compare it to "OES".
So we are standardizing it all for the sake of the comparsion to remove the different ways it may be entered.

Can I create 5 macros by just changing the name. From "James" to XXX, YYY, ZZZ, WWW.? on same workbook??
I can copy the same vba and add as new with new name?
your thoughts please??

 

[Joe4]

Can I create 5 macros by just changing the name. From "James" to XXX, YYY, ZZZ, WWW.? on same workbook??
I can copy the same vba and add as new with new name?
your thoughts please??

I don't understand what you are asking here, or how it relates to the original question.

 

[FGaxha]

I don't understand what you are asking here, or how it relates to the original question.

Sorry, my fault.