converting table back to range

  • Thread starter Thread starter Kenny Louden
  • Start date Start date
K

Kenny Louden

I'm trying to convert a table back into a range via a macro using Excel 2007,
and I'm having a hard time finding the method.

I tried recording the macro, but it's not picking up the steps whenever I
goto the Table Tools ~ Tools and click 'convert to range'.

Any advice is greatly appreciated.
Thanks
kenny
 
I understand that MS changed the xl2003 "List" object to a "Table" object.
The list object has an "Unlist" method.
I bet that the xl 2007 table has something very similar.
Check out the help file... Untable? <g>
--
Jim Cone
Portland, Oregon USA



"Kenny Louden"
<[email protected]>
wrote in message
I'm trying to convert a table back into a range via a macro using Excel 2007,
and I'm having a hard time finding the method.
I tried recording the macro, but it's not picking up the steps whenever I
goto the Table Tools ~ Tools and click 'convert to range'.
Any advice is greatly appreciated.
Thanks
kenny
 
Jim,
Thanks for the information.
Believe or not it's still the Unlist method of the ObjectList. Go figure.

kenny
 
under the "Table Tools" group, you'll find a "convert to range" method. so
it can be done manually, tho' I haven't discovered how to code it (yet)
 
doh

Sub removeTable()
Dim lo As ListObject
Set lo = ActiveSheet.ListObjects(1)
lo.Unlist
set lo = nothing
End Sub

sorry - i should pay more attention. well, its Monday ...
 
Back
Top