Stuck Userform working with Worksheet

[blacktour]

I am close to getting this code to work but I get the most ridiculous sporadic errors and am getting frustrated. I have no idea why it freezes, sometimes it will give me errors like "End Sub", or Next x (random numbers), then the y=y + 31 is an error its never the same, then all of a sudden the code works find and does exactly what it is programed to do???

Anybody have any ideas. I am assuming I am missing something pretty important.

Private Sub cmdUpdate_Click()
Application.ScreenUpdating = False

Dim NumofTaxYr As Double
Dim TaxCalcSht As Worksheet
Dim y As Double
' Dim z As Double

Set TaxCalcSht = Worksheets("Tax Calc")
TaxCalcSht.Activate

NumofTaxYr = Val(cmbTaxYrEnd.Value) - Val(cmbTaxYrStart.Value) + 1

y = 10
' z = 0

For x = 1 To NumofTaxYr
TaxCalcSht.Rows(y & ":" & y + 29).Select
Selection.Copy

y = y + 31
' z = z + 1

TaxCalcSht.Rows(y & ":" & y).Select
ActiveSheet.Paste

' Cells(y + 1, 2).Value = cmbTaxYrStart.Value + z

Next x

TaxCalcSht.Range("A1").Select
Application.CutCopyMode = False
Unload Me
Application.ScreenUpdating = True
End Sub

 

[blacktour]

If I set a break point at Next X and keep clicking play and letting it break at next x it works every time, so I guess its something related to how the userform interacts with the worksheet? Not sure how to fix it.

 

[RoryA]

What is the actual error message, or is it just a 'code execution was halted' type message?

 

[blacktour]

What is the actual error message, or is it just a 'code execution was halted' type message?

The error is always "code execution has been interrupted"?

 

[RoryA]

I don't think it's an actual error then - it's a VBE glitch. See here for some options using Application.EnableCancelKey
There are also some discussions on this forum somewhere.

 

[blacktour]

I don't think it's an actual error then - it's a VBE glitch. See here for some options using Application.EnableCancelKey
There are also some discussions on this forum somewhere.

Thanks so much, it is working everytime I restarted excel and used this and its fine. I have been programming VBA on and off for quite a few years and haven't ran into this one yet lol.
Thanks again,
Mike