I'm doing a root finder using Newton's Method and it will run fine in my spreadsheet but when I do a step through i get an overflow runtime error and I'm not sure why. I've tried changing the variables from double to long but it doesn't seem to help.
Option Explicit
Sub NewtonMethod()
'...