I've built a simple loop as follows:
For x = 0 To 4 Range(Range(CellsCornerCell).Offset(0, x), Range(CellsCornerCell).Offset(2, x)).Select Selection.HorizontalAlignment = xlCenterAcrossSelection Selection.BorderAround (xlContinuous) Next x
I also had another loop which is exactly the same but the range was x = 8 To 11. How can I join the two loops together? I thought it would be something simple like For x = 0 To 4 & 8 To 11, but nothing like that works.