谨以此网站,向Godick致敬

with sheet1
    name = .cells(i,1)
    company = .cells(i,2)
end with

const nameCol = 1 , companyCol = 2
with sheet1
    name = .cells(i,nameCol)
    company = .cells(i,companyCol)
end with

Private Enum AllCols
  nameCol = 1
  companyCol
End Enum

with sheet1
    name = .cells(i,AllCols.nameCol)
    company = .cells(i,AllCols.companyCol)
end with

Const nameCol = "name", companyCOl = "company"

set tbl = Sheet1.ListObjects("tableName")
with sheet1
  For each row in tbl.ListRows
    name = row.range(, col(nameCol))
    company = row.range(, col(companyCol))
    'do something
  next row
end with