To create a table from cells A1:F6, and assuming the table has column headers : ListObject « File Path « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. File Path
  3. ListObject

To create a table from cells A1:F6, and assuming the table has column headers

 
Sub table()
    ActiveSheet.ListObjects.add(xlSrcRange, range("$A$1:$F$6"), , xlYes).name = "Table1"
End Sub








Related examples in the same category

1.Inspecting a ListObject
2.Creating a Custom XML List