Excel VBA Union Method for Range
Union Method returns a Range which is combined from two or more Range. In the above diagram, Union A and B returns area A plus B, where the intersection area only counts once.
The first time I used Union was that I needed to do several formatting for several columnS but they were not side by side. For example, I need to change color for column A, column C and column Z, the best way to do is to combine all three columns as a new Range, and then apply c...
Read More