goneps
New member
On a workbook with 8 worksheets, only Worksheets(3) contains formulae calling a UDF (which recalculates the relative position of a referenced cell when a row is added, moved, or removed).
However, when debugging a short routine which uses only WS(1) and (2), the UDF is being called unnecessarily despite nothing changing on WS(3) and that worksheet's not even active. Presumably this is happening every time the workbook recalculates. In normal use it's not an issue, but is an irritating distraction when stepping through new code.
Is there any way to prevent this?
Thanks!
However, when debugging a short routine which uses only WS(1) and (2), the UDF is being called unnecessarily despite nothing changing on WS(3) and that worksheet's not even active. Presumably this is happening every time the workbook recalculates. In normal use it's not an issue, but is an irritating distraction when stepping through new code.
Is there any way to prevent this?
Thanks!