File Path VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. File Path
  4. To create a table from cells A1
Sub table()
    ActiveSheet.ListObjects.add(xlSrcRange, range("$A$1:$F$6"), , xlYes).name = "Table1"
End Sub