How do I loop an excel 2010 table by using his name & column reference?

by

I’m not very familiar with the shorthand method of referring to tables. If you don’t get an answer, you might find this longhand method, that uses the ListOject model, useful:

Sub ListTableColumnMembers()
Dim lo As Excel.ListObject
Dim ws As Excel.Worksheet
Dim lr As Excel.ListRow

Set ws = ThisWorkbook.Worksheets(2)
Set lo = ws.ListObjects("tabWorkers")

For Each lr In lo.ListRows
Debug.Print Intersect(lr.Range, lo.ListColumns("FirstName").Range).Value
Next lr
End Sub

More Related Contents:

  1. VBA – How to grab the cell below if a cell has text?
  2. Getting ScriptControl to work with Excel 2010 x64
  3. Pop up the Excel Statusbar?
  4. Get list of Excel files in a folder using VBA [duplicate]
  5. When one should use Set [e.g for SpecialCells return value]?
  6. Should I turn .CutCopyMode back on before exiting my sub procedure?
  7. Determine if cell contains data validation
  8. Sheet protection: UserInterFaceOnly gone
  9. VBScript – How to make program wait until process has finished?
  10. How to highlight a cell using the hex color value within the cell?
  11. Removing special characters VBA Excel
  12. Open an Excel file from SharePoint site
  13. VBA recognizing workbook by partial name
  14. Excel VBA wildcard search
  15. Excel VBA Project has generated multiple Workbook objects
  16. Copy an entire worksheet to a new worksheet in Excel 2010
  17. Loop through files in a folder using VBA?
  18. filter out multiple criteria using excel vba
  19. Run same excel macro on multiple excel files
  20. VBA : save a file with UTF-8 without BOM
  21. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  22. VBA – Range to jpg picture
  23. Making VBA Form TextBox accept Numbers only (including +, – and .)
  24. Inserting an Online Picture to Excel with VBA
  25. Change length of For loop while in the loop
  26. VBA – Run Time Error 1004 ‘Application Defined or Object Defined Error’
  27. Consolidating worksheets into one
  28. How do I open a file if I only know part of the file name?
  29. How to call function from another specific workbook in VBA?
  30. Open Google Chrome from VBA/Excel

Leave a Comment