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