Thank you!!

I have grabbed parts of your code and combined it with code I had
already started making some progress on.

The IsNumeric function wasn't working for me. I think it was because
the values in the cells I was referring to were a result of an IF
statement (not direct user input values as I indicated), not sure. I
used IsError instead and applied it to the ActiveCell since I didnt
need to do FindRoot when a VALUE error was present.

Works great! :)


--
mtnbikr9
------------------------------------------------------------------------
mtnbikr9's Profile: http://www.excelforum.com/member.php...o&userid=35429
View this thread: http://www.excelforum.com/showthread...hreadid=551992