| |
昔作った、どこにでもあるSortで横位置にも対応してみた。
Sub test02()
Dim Pic As Picture
Dim i As Long
ReDim PicList(0 To ActiveSheet.Pictures.Count - 1, 0 To 2) As Variant
For Each Pic In ActiveSheet.Pictures
PicList(i, 0) = Pic.Name
PicList(i, 1) = Pic.Left
PicList(i, 2) = Pic.Top
i = i + 1
Next
Call BubbleSort(PicList, 1)
Call BubbleSort(PicList, 2)
For i = 0 To ActiveSheet.Pictures.Count - 1
ActiveSheet.Pictures(PicList(i, 0)).ShapeRange.ZOrder msoBringToFront
Next
End Sub
Sub BubbleSort(ByRef Ary() As Variant, ByVal key As Long)
Dim swap As Variant
Dim i As Long
Dim j As Long
Dim k As Long
For i = LBound(Ary, 1) To UBound(Ary, 1)
For j = UBound(Ary, 1) To i Step -1
If Ary(i, key) > Ary(j, key) Then
For k = LBound(Ary, 2) To UBound(Ary, 2)
swap = Ary(i, k)
Ary(i, k) = Ary(j, k)
Ary(j, k) = swap
Next
End If
Next
Next
End Sub
左上から右へと並び替えてます。
下へ向かうなら、
Call BubbleSort(PicList, 2)
Call BubbleSort(PicList, 1)
キーの順番を変えてください。
|
|
![[未読]](./data/excel/image/read_icon.gif){kind=icon}
