Problem with comparing (excel related)

[MrSafe]

Problem: Basically all the vi does is grab values from excel and compare it with a pre-determined value and if the returned value is greater than or equal the vi stops and returns the cell which gave it thar value. I think it may that I am telling excel to compare a string value to a decimal value but I have tried that and it seems to stop instantly with a value which is cleary wrong.

I have attached the vi and  sample excel file which it searchs through

[mikeporter · Accepted solution]

Don't see a problem. Start at A4 and it stops on the first iteration as it should (because the cell is blank it converts to a 0 which is greater than -30). Starting at A5 it steps down to A368, again just as it should.

Mike...

[MrSafe]

Did you do anything to the vi to get that result? for me the result is ALWAYS A5 which is incorrect.

[MrSafe]

I managed to get it to work. I am not even sure how because I didn't do anything.  But it works now, thanks!

Message Edited by MrSafe on 02-10-2009 12:51 PM