Try stepping though to code. Use Debug.Print and Watch to see what is happening and identify the errors.