Stack overflow problem

[Trickle]

Hi All

I keep getting a Stack Overflow problem when the following code is run in an Excel sheet I'm using:

Private Sub Worksheet_Calculate()

If Range("AG1") > 0 Then Call Reset_Bet_Sheet1
If Range("J4") = "Y" Then Call Bf30Prices
If Range("AG2") > 0 Then Call Green

End Sub

I want the three macros to be triggered at different times over a fifteen minute period and have cell inputs set up on the sheet for this to trigger the macros, but it won't run because of the Stack Overflow issue.

Any help for a VBA novice would be much appreciated.

Trickle

 

[NeonRedSharpie]

Obviously your error is in one of those three macros. I'm guessing you have a string that is too long or a declared integer that should be a long.

 

[shg]

If any of those macros changes the worksheet, then it retriggers the Change event, which re-runs the macro, which retriggers the Change event, ...

Disable events (Application.EnableEvents = False) in those routines before making changes, then enable events on exit.

 

[Trickle]

Many thanks for your quick responses. I'll correct the macros and get back.

Trickle

 

[shg]

You're welcome.