Range.Item 和 Range.Cells 之间有什么区别

根据 Range.Item 和 Range.Cells 之间有什么区别？

Sub RangeExample()
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Worksheets("Sheet1")
    
    ' 使用Range.Item访问单个单元格
    Dim cell As Range
    Set cell = ws.Range("A1")
    cell.Value = "Hello"
    
    ' 使用Range.Cells访问多个单元格
    Dim range As Range
    Set range = ws.Range("B1:C2")
    range.Value = "World"
    
    ' 使用Range.Item和Range.Cells进行批量操作
    Dim i As Integer
    For i = 1 To 10
        ws.Range("D" & i).Value = i
    Next i
    
    ' 使用Range.Cells获取整个工作表的范围
    Dim entireSheet As Range
    Set entireSheet = ws.Cells
    ' 对整个工作表进行操作
    entireSheet.ClearContents
End Sub