When i press F8 to check my Code

[mark692]

hi there i have a few modules with macro,

when i used F8 to check my code in a module, it brings me to other macro with Functions even though its not part of my code that im testing with F8?

i notice the code are always with "Function" at the beggining, can i avoid it? thanks

 

[Yongle]

That behaviour happens when a function is used inside the macro
If you require further help ... post the macro being checked

 

[Peter_SSs]

That behaviour happens when a function is used inside the macro

It occurs for me even when the function is not called from the macro I am stepping through but if the function is being used in a worksheet cell formula (in any sheet in the workbook). I'm assuming that is what the OP is experiencing too.

I'm not sure if there is an easy way to disable this but I often comment out the function(s) temporarily, or look at some of the options in the vba Debug menu:

 

[mark692]

It occurs for me even when the function is not called from the macro I am stepping through but if the function is being used in a worksheet cell formula (in any sheet in the workbook). I'm assuming that is what the OP is experiencing too.

I'm not sure if there is an easy way to disable this but I often comment out the function(s) temporarily, or look at some of the options in the vba Debug menu:
View attachment 18415

yes this is what i mean, ill try this one, thanks

 

[Yongle]

In that case, something else to try could be to set calculations to manual (see formula tab) whilst stepping through the macro
- remember to set to automatic afterwards

This suggestions is not helpful if sheet calculations are required when stepping through the code