Compare Excel string with Extra variable

[nrm3]

I am scanning the 1st column of an excel sheet in order to find a specific row.
I can see the excel string in a Msgbox ,but can not compare it to an excel variable.

MyData.value = XL.application.worksheets("EMUX").Range(Cstr("A" & row)).Value

Msgbox MyData.value

If( MyData.value = CLO) Then 'CLO = extra variable

GoTo label_FoundClo

End if


This code does not work for me. Any ideas?

 

[SkipVought]

Hi

What exact value is in your CLO variable?

How is MyData declared.

Please post your code

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]