How to merge VBA Code.
xlCompare finds 3 types of the differences in the VBA Code: Each type of difference has a number of commands to resolve it.
Added lines:
This code can be added to the left module or deleted from the right one. Both operations can be performed from the right-click-menu on the selected block of the code:
Or from the toolbar, which has same commands:
"Green Arrow" button adds this code the left module. And "Delete" button removes selected lines from the right module.
Deleted lines:
This code can be added to the right module or deleted from the left one. Both operations can be performed from the right-click-menu on the selected block of the code:
"Green Arrow" button on the toolbar adds this code the right module. And "Delete" button removes selected lines from the right module.
Changed lines:
In this case code can be coped from the left module to right or from the right to left. Also, you can delete this line. You should select the line you want to copy or to delete and use appropriate command from the right-click-menu or toolbar:
"Green Arrow" button on the toolbar copies this code to another module. And "Delete" button removes selected lines from the selected module.