converting table back to range

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
 
J

Jim Cone

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
 
K

Kenny Louden

Jim,
Thanks for the information.
Believe or not it's still the Unlist method of the ObjectList. Go figure.

kenny
 
P

Patrick Molloy

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)
 
P

Patrick Molloy

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 ...
 
Top