Select Multiple Ranges

Hello All

I have 2 ranges which on their own seem to work fine (I have check by just putting ".Select" at the end of both of them)

The issue is that I want to apply the same border format to both ranges, however, when I try to put them together in a "With" statement it includes all of the range from the top to the bottom and not just the 2 two ranges.

Ranges being used:

Please Login or Register  to view this content.

Code I'm using trying to put both Ranges together:

Please Login or Register  to view this content.

If anyone could point out where I'm going wrong it would be most appreciated.

Thanks in advance

Jim

Use UNION to combine two ranges

Please Login or Register  to view this content.