caption sensitivity
 

hello,

I've got an interesting problem. I am searching for a string in a
macro. e.g. animal
but the variable is set as Animal. How can i make sure case sensitivety
is not an issue for a variable.

Regards,
Niek


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

caption sensitivity
 

One way is to use the UCASE function to convert your
searched string to upper case. For example

For x = 1 to 10

If Ucase(cells(x,1).value) = "ANIMAL" Then
... do something exciting ...
End if

Next X

Cheers, Pete

-----Original Message-----

hello,

I've got an interesting problem. I am searching for a
string in a
macro. e.g. animal
but the variable is set as Animal. How can i make sure
case sensitivety
is not an issue for a variable.

Regards,
Niek


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.

caption sensitivity
 

Or put Option Compare Text at top of module above any procedures.

Gord Dibben XL2002

On Mon, 10 Nov 2003 00:54:26 -0800, "Pete McCosh" wrote:

One way is to use the UCASE function to convert your
searched string to upper case. For example

For x = 1 to 10

If Ucase(cells(x,1).value) = "ANIMAL" Then
... do something exciting ...
End if

Next X

Cheers, Pete

-----Original Message-----

hello,

I've got an interesting problem. I am searching for a
string in a
macro. e.g. animal
but the variable is set as Animal. How can i make sure
case sensitivety
is not an issue for a variable.

Regards,
Niek


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.