Vba: Tables & ranges

[Nanogirl21]

Is there a VBA option to convert a Table (table name is Tracking on sheet called Tracking) into a standard excel range? The table is in columns A-AE. The table will constantly grow, so there is no definante number for rows.

On the other side. Is there a VBA option to convert a range into a table?
Range = A-AE on sheet called Math
Table Name = Math FINAL
Table Formatting = Custom Style called Math View (I went to HOME > STYLES > FORMAT AS TABLE > NEW TABLE STYLE)

 

[Norie]

To convert to a range.

Sheets("Tracking").ListObjects("Tracking").Unlist

To create a table.

Dim wsMath As Worksheet
Dim tbl As ListObject

    Set wsMath = Sheets("Math")
    
    With wsMath
        Set tbl = .ListObjects.Add(xlSrcRange, .Range("A1").CurrentRegion)
        tbl.Name = "Math Final"
        tbl.TableStyle = "Math View"
    End With

 

[Nanogirl21]

Thank you.