Revision history [back]

There could be a few reasons why a specific section of the macro VBA code is not being executed even though no error is being returned:

1. The code is being skipped due to a conditional statement that is not being met. Check if there are any If/Else or Case statements that could be affecting the flow of the code.

2. The code is being overwritten by a subsequent code block. Check if there is any overlapping code or if there are any other subs or functions that may be interfering with the current code.

3. The code is not being called properly. Ensure that the code is being called from the correct location and that all necessary parameters are being passed.

4. The code is relying on external factors, such as user input or environmental variables, that may not be arriving as expected. Check if all inputs are correctly provided and if there are any environmental issues that may be interfering with the code execution.

In any case, it may be helpful to add debugging statements or breakpoints to the code to better understand where the issue occurs.