VBA／select contiguous cells as separate batches

[smallxyz]

Hi

Say, A1:A6 are to be selected but with 2 cells as a group, i.e. A1:A2,A3:A4,A5:A6
I tried

With ActiveSheet
Union( .Range("A1:A2"), .Range("A3:A4"), Range("A5:A6")).Select
End With

However, the result is A1:A6 being selected instead of 3 selection batches A1:A2, A3:A4 and A5:A6
The above is a simplified case of my scenario. I just wonder, if in general, there is a way for VBA to group selected contiguous cells by N number as a batch, and return contiguous selection as separate batches ( like what we select using Ctrl + MouseLeftClick on cells ).

 

[smallxyz]

You didn't really answer @Joe4's questions in post #4, it is not considered to be good practice to "select" objects in VBA so giving that as a goal doesn't really help.

Are you sure one of the 2 options below wouldn't work for you ?

Sub RangeAreas_UsingArray()

    Dim rngFull As Range
    Dim rngPart As Range
    Dim sAddr As Variant
    Dim i As Long
   
    sAddr = Array("A1:A2", "A3:A4", "A5:A6")
   
    For i = 0 To UBound(sAddr)
        Debug.Print Range(sAddr(i)).Address, Range(sAddr(i)).Cells.Count
    Next i

End Sub


Sub RangeAreas_UsingString()

    Dim rngFull As Range
    Dim rngPart As Range
    Dim sAddr As Variant
    Dim i As Long
   
    sAddr = Split("A1:A2,A3:A4,A5:A6", ",")
   
    For i = 0 To UBound(sAddr)
        Debug.Print Range(sAddr(i)).Address, Range(sAddr(i)).Cells.Count
    Next i

End Sub

Sorry. This is a necessary step to use "Select" to continue and glue to the written codes later on.

I just wanna see if VBA is able to select contiguous cells in batches at a large scale. I know I can loop selected contiguous cells through（either forward of backward）and manipulate those batches alone by setting N = 2. However, it may not fit well into the codes under next level of tasks. And there will be a hard time to rewrite everything.

 

[Joe4]

Sorry. This is a necessary step to use "Select" to continue and glue to the written codes later on.

I just wanna see if VBA is able to select contiguous cells in batches at a large scale. I know I can loop selected contiguous cells through（either forward of backward）and manipulate those batches alone by setting N = 2. However, it may not fit well into the codes under next level of tasks. And there will be a hard time to rewrite everything.

I still think there is a good chance that you many not to select any of these ranges in order to work with them.
But if you don't show us what these "other codes" look like, there isn't any way for us to know for sure or provide you with alternatives.