VBA CTRL F8 debugging

Anonymous
2023-06-29T15:05:14+00:00

i have some VBA code i am trying to debug. i have done this before without issue. i go to the Sub kg () line and hold CTRL while clicking F8. the line executes. then, i click F8 and it executes the next line and so on. then, after a few lines execute 1 by 1, the next click of F8 tries to run the remaining code and stops going line by line.

does anyone know how to fix this where it will go line by line?

ty

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2023-06-29T16:03:48+00:00

Could you share your macro file without sensitive information to reproduce your issue? Then we may help you to find the cause of it.

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

Answer accepted by question author

Anonymous
2023-06-29T20:26:59+00:00

Could you share your macro file without sensitive information to reproduce your issue? Then we may help you to find the cause of it.

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

After I killed excel it seemed to start working so i will mark this as fixed. i saw others in the past had posted something similar but i did not see the answer so i thought i would ask. TY. posting fixed with reboot.

Was this answer helpful?

0 comments No comments

0 additional answers

Sort by: Most helpful