Dim thenumber, theterms, z As Integer
This is an incorrect way of dimming

Try this
VB Code:
  1. Dim thenumber As Integer, theterms As Integer, z As Integer