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"
<(E-Mail Removed)>
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

"Jim Cone" wrote:

>
> 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"
> <(E-Mail Removed)>
> 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
>
>

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)



"Kenny Louden" <(E-Mail Removed)> wrote in message
news:A4369817-453B-4ABF-AB48-(E-Mail Removed)...
> Jim,
> Thanks for the information.
> Believe or not it's still the Unlist method of the ObjectList. Go figure.
>
> kenny
>
> "Jim Cone" wrote:
>
>>
>> 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"
>> <(E-Mail Removed)>
>> 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
>>
>>

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


"Patrick Molloy" <(E-Mail Removed)> wrote in message
news:F6ED6EF5-872D-4DB9-9789-(E-Mail Removed)...
> 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)
>
>
>
> "Kenny Louden" <(E-Mail Removed)> wrote in message
> news:A4369817-453B-4ABF-AB48-(E-Mail Removed)...
>> Jim,
>> Thanks for the information.
>> Believe or not it's still the Unlist method of the ObjectList. Go figure.
>>
>> kenny
>>
>> "Jim Cone" wrote:
>>
>>>
>>> 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"
>>> <(E-Mail Removed)>
>>> 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
>>>
>>>