Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting table back to range
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting table back to range
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" 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting table back to range
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" 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting table back to range
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" wrote in message ... 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" 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting table back to range
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" wrote in message ... 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" wrote in message ... 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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Pivot table back to Data Table | Excel Discussion (Misc queries) | |||
convert Pivot table back to Data table | Excel Discussion (Misc queries) | |||
Converting text string back into a formula | Excel Discussion (Misc queries) | |||
CONVERTING AN EMPTY TEXT BACK TO BEING BLANK | Excel Programming | |||
Transforming pivot table back to the source table | Excel Worksheet Functions |