View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Excel Hangs when using Offset in formula. A bug?

I was wondering if you had
Private Sub Worksheet_Calculate()

End Sub
or
Private Sub Workbook_SheetCalculate(ByVal Sh As Object)

End Sub

Depending on what you are up to you could end up with a recursive call of
these procedures. That being said have you tried stepping through your code
with F8 to see what the actual flow of execution is?
--
HTH...

Jim Thomlinson


"Bart" wrote:

Thanks Jim Thomlinson for replying,

No I don't use the event "Private Sub object_Calculate()".
It looks suspiciously like an endless loop: Excel uses 99% of my CPU
when it hangs. I have to use the Task Manager to break of Excel.

Bart