Dnia 27 Jun 2006 14:15:39 -0700, atemesov napisa³(a):

[...]
Currently I have switched to Excel 2003 and uncovered that this
construction (Application.Transpose) behaves differently:
Suppose you have inserted a break point inside of the function that
uses Application.Transpose
When execution comes to the point when you use that variant Array
suddenly execution of the function starts again from the beginning of
[...]

I've just tested this code:

Sub aaa()
Dim v As Variant
' breakpoint below
v = Application.WorksheetFunction.Transpose(Range("C5: E7"))
End Sub

Sub bbb()
aaa
End Sub

Pressing F5 inside bbb executes to breakpoint. Then, after pressing F5 or
F8 debugger behaves OK.

Maybe you have some Loop or recurring _Change event...

--
PL