Disregard whether field has caps in it

[Lball]

Hello everyone,

How do i get my macro to NOT care if cell has caps in it while using an if statement. Here is a bit of my code:

If Cells(myRow, "H") = "IndyMac" Then
        With Range(Cells(myRow, 2), Cells(myRow, 10))
            .Copy Sheets("INDYMAC").Cells(Rows.Count, "B").End(xlUp).Offset(1)
            .Delete xlUp
        End With
Else........(Blah blah blah)

If my cell in (myRow, "H") has INDYMAC or indymac or Indymac, then the macro doesn't do what i want it to. Is there a way to tell the macro to just look at the letters instead of which letters are caps? Or do i have to add additional If statements for other possibilities?

Thanks in advance for any help!

 

[Norie]

There are various ways to do this.

One way is to put this at the top of the module.

Option Compare Text

 

[Scott Huish]

Another way is like this:

If UCase(Cells(myRow, "H")) = "INDYMAC"

 

[lenze]

Hi:
Change your first line

If Cells(myRow, "H") = "IndyMac"

to

If UCase(Cells(myRow, "H")) = "INDYMAC"

HTH
lenze

 

[Lball]

Adding that line alone creates a compile error, "Invalid Inside Procedure"

 

[Lball]

changing line to ucase doesn't work either

 

[Lball]

nevermind i forgot to capitalize "INDYMAC" Its working now, THANKS!

 

[Norie]

That line should go at the top of the module, not within any procedure.

How did the UCase not work?

What exactly did you try?

 

[lenze]

Since my friend HOTPEPPER and I BOTH gave the same response, I must doubt how you have implemented it. Can you provide details of EXACTLY what is happening?

lenze

 

[Lball]

In case you missed my earlier post.....it was my error i forgot to capitalize INDYMAC in the if statement after i added ucase. Its working now.

As for Option Compare Text, i added that line right after my Sub line and it came back with the compile error that i mentioned. NOt concerned with it now cause the other suggestion worked.

THank you all for your help.