xlCompare finds 3 types of the differences in the VBA Code:
- Added lines (lines, which are not found in the left module)
- Deleted lines (lines, which are not found in the right module)
- Changed lines (lines, which have difference text)
Each type of difference has a number of commands to resolve it.
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:
"Green Arrow" button adds this code the left module. And "Delete" button removes selected lines from the
right module.
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.
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.