For循环是EXCEL VBA中最常用的循环语句之一，我们通过生成乘法口诀表来学习这个语句，先来看看结果演示：

是不是很快

代码+注释

EXCEL精华，EXCEL教程，必须掌握的职场技巧，没有它，你寸步难行，不要说你不会。

每天分享学习资源（第18天），坐等吐槽，有错请指出纠正。

For Next嵌套循环2

列与行相乘

代码：

Sub 列行相乘()

Dim rng As Range, rng2 As Range

直接看代码和注释：

Option Explicit
Sub SortSheets()
' This routine sorts the sheets of the
' active workbook in ascending order.
' Use Ctrl+Shift+S to execute
 Dim SheetNames() As String
 Dim i As Long
 Dim SheetCount As Long
 Dim OldActive As Object
 
 If ActiveWorkbook Is Nothing Then Exit Sub ' No active workbook
 SheetCount = ActiveWorkbook.Sheets.Count
 
' Check for protected workbook structure
 If ActiveWorkbook.ProtectStructure Then
 MsgBox ActiveWorkbook.Name & " is protected.", _
 vbCritical, "Cannot Sort Sheets."
 Exit Sub
 End If
' Make user verify
 If MsgBox("Sort the sheets in the active workbook?", _
 vbQuestion + vbYesNo) <> vbYes Then Exit Sub
' Disable Ctrl+Break
 Application.EnableCancelKey = xlDisabled
 
' Get the number of sheets
 SheetCount = ActiveWorkbook.Sheets.Count
 
' Redimension the array
 ReDim SheetNames(1 To SheetCount)
' Store a reference to the active sheet
 Set OldActive = ActiveSheet
 
' Fill array with sheet names
 For i = 1 To SheetCount
 SheetNames(i) = ActiveWorkbook.Sheets(i).Name
 Next i
 
' Sort the array in ascending order
 Call BubbleSort(SheetNames)
 
' Turn off screen updating
 Application.ScreenUpdating = False
 
' Move the sheets
 For i = 1 To SheetCount
 ActiveWorkbook.Sheets(SheetNames(i)).Move _
 Before:=ActiveWorkbook.Sheets(i)
 Next i
' Reactivate the original active sheet
 OldActive.Activate
 
End Sub
Sub BubbleSort(List() As String)
 Dim First As Long, Last As Long
 Dim i As Long, j As Long
 Dim Temp As String
 First = LBound(List)
 Last = UBound(List)
 For i = First To Last - 1
 For j = i + 1 To Last
 If UCase(List(i)) > UCase(List(j)) Then
 Temp = List(j)
 List(j) = List(i)
 List(i) = Temp
 End If
 Next j
 Next i
End Sub