Vba_excel_ Tutorial: Table, Lattice

Subtables and grids ()'Define a worksheet    DimWs asWorksheet'get sheet by name "See table name, or ordinal number, ...", to add set    SetWS = Worksheets ("Table") Set ws = Worksheets (1)

    ' 1, 2:cell contents (the page corresponds to range, the coordinates correspond to cells)Debug.Print ws.Range("B1") Debug.Print ws. Cells (1,1)
　　
TMP = Cells (1, 1). Value ' 3: Variable not defined, sheet of current write code
End Sub

Sub traverse All tables ()      for  each inch Worksheets        Debug.Print ws. Name    NextEnd Sub

Sub traversing part of a table    ()  for 1  to 2 ' I do not define        Dim  as Worksheet         Set ws = Worksheets (i)                Debug.Print ws. Name    NextEnd Sub

Vba_excel_ Tutorial: Table, Lattice