How to quickly identify the "offender" code? - Debuging VBA

[actjfc]

Excel Friends,

I got a large Excel workbook with too many VBA modules/procedures/functions to count. One of the sheets is governed by many macros that also call other macros. This specific sheet has one range that changes its size by populating some rows from n to m (via the user interface), where m varies, m>n. I need to debug some issues about "m," How can I quickly identify the "offender" code? I mean the code that changes the "m" value. I should say that there is a kind of named range that changes somewhere in the code while running.

Thanks for any help!

 

[SpillerBD]

Setup a Watch of that value while using the Step Into Debugger option.
There are some options to let the code run until a variable hits a certain value as well.

 

[actjfc]

Thanks for the tip! I found many useful explanations about this debugging "Step Into" procedures in youtube.com. For example, this channel has a few good videos about debugging: https://www.youtube.com/channel/UCQkM3K_8XfGyrG8_hNJaIeg

Thanks!