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
|