I have edited a program that can find the best location on the board and taper down to the worst location. It is based off Excel and you can download the original program here
http://www.chiefdelphi.com/media/papers/1907? . I have edited the program but i have a problem finishing this set of code in VB.
>>Public Function Change()
>> If newHigh = newHigh2 Then
>> cell.Interior.ColorIndex = 4 'It says the error is here
>> cell2.Interior.ColorIndex = 4 'And it could be here
>> If newHigh = newHigh3 Then
>> cell3.Interior.ColorIndex = 4 'And here
>> If newHigh = newHigh4 Then cell4.Interior.ColorIndex = 4 'and here
>> End If
>> Else
>> cell.Interior.ColorIndex = 4 'and finally here
>> End If
>>End Function
Every time the program gets to this part of the code it gives a runtime error of '424'. I've defined the ranges and specified a variable with a type 'Range' which are called 'cell' 'cell2' etc. You get the point. If anyone can help me figure this out it would be greatly appriciated. I just started to learn VB like a week ago. I know Java, some C and C#, QBasic, TI-Basic (the graphing calculator language), and was going to try and teach myself HTML to create a proxy (just for fun). That's my experience. Hope you guys can help me out.