vba – ListObject Error upon applying an Unlist Method
Basically, I have an Excel Formatted Table called “TestTable” in my activesheet. That’s the only table in that sheet. I’m trying to convert it to a normal range. From looking up online, this should be simple, all I have to do is Unlist
that table object.
However, my VBA code is throwing an error. Any pointers in the right direction would be greatly appreciated.
Sub ConverToNormalRange()
Dim objListObj As ListObject
Set objListObj = ActiveSheet.ListObjects(1)
objListObj.Unlist
End Sub
When I run the above macro, I get the following error:
Read more here: Source link