[lurburlnxc]

I need some VB help in excel. I just learned vb like 2 days ago and everything is fine except i get a runtime error '424' everytime i run this function.
>>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
I have basically added to the program and have taken nothing out of it. Good job though on your work. You may want to fix the problem with adding too many ringers after the autonomous mode.