Is there a way to "Convert Table to Range" in VBA?

[TomCon]

If i use the "Format as Table" command and record it, VBA records Activesheet.ListObjects.Add...

But, if i then use the Table Tools Ribbon, "Convert To Range", nothing is recorded. (Tried it several times, always the same).

Can i do the effect of the command "Convert To Range" in VBA in any way?

Thanks!
Tom

 

[RoryA]

Assuming you have it selected:

Selection.ListObject.Unlist

 

[Peter_SSs]

If you know a particular cell is in the table

Range("K1").ListObject.Unlist

 

[TomCon]

Yes, either "Selection" or "Range" does it. Funny they don't record it. I guess its a small bug!
Thanks very much!
tom