Sub AddTable()
ActiveSheet.ListObjects.Add(xlSrcRange,
ActiveSheet.UsedRange, , xlNo).Name = "Table1"
Range("Table1[[#All],[Column1]]").Select
End Sub
ActiveSheet.ListObjects.Add(xlSrcRange,
ActiveSheet.UsedRange, , xlNo).Name = "Table1"
Range("Table1[[#All],[Column1]]").Select
End Sub
No comments:
Post a Comment