There were a couple other bugs in
there, but I got through them. I have a couple more
questions, things which bugged me but I got around
them anyway.

1) I had to replace WorksheetFunction.SQRT(2) with
2^(1/2), because SQRT was giving me a #VAL error. Any
idea why?

2) The only way I can get Excel to recalculate the
value of these cells after changing the code  is if I
go into the formula  bar for each cell and change
something. This is somewhat prohibitive because I
have 9,877 rows. Is there a way to get Excel to
calculate all these at once?