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