none
How to convert a Table to a Range in code (Excel 2010)

    Question

  • Hi Folks,

    How does one convert a table to a normal range via VBA in Excel 2010.  This is the command found under Table Tools, Convert to Range.  This is not a pivot table.

    Help seems useless.

    TIA,

    Shane


    If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

    Friday, March 01, 2013 10:25 PM

Answers

  • In VBA tables represented as ListObject.Use unlist method of this object for converting to normal range.

    ActiveSheet.ListObjects(1).Unlist


    Best Regards,
    Asadulla Javed, Kolkata
    ---------------------------------------------------------------------------------------------
    Please do not forget to click “Vote as Helpful” if any post helps you and "Mark as Answer”if it solves the issue.

    Saturday, March 02, 2013 4:58 AM
    Answerer

All replies

  • In VBA tables represented as ListObject.Use unlist method of this object for converting to normal range.

    ActiveSheet.ListObjects(1).Unlist


    Best Regards,
    Asadulla Javed, Kolkata
    ---------------------------------------------------------------------------------------------
    Please do not forget to click “Vote as Helpful” if any post helps you and "Mark as Answer”if it solves the issue.

    Saturday, March 02, 2013 4:58 AM
    Answerer
  • Hi Shane,

    I temporarily marked the reply as answer. You can unmark it if it provides no help.

    Please feel free to let us know if you need any help.

    Have a nice day.


    Quist Zhang [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, March 14, 2013 7:27 AM
    Moderator
  • Thanks,

    I'll try it.

    Shane


    If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

    Thursday, March 14, 2013 12:05 PM
  • Unlist worked.  Thanks.
    Friday, May 17, 2013 4:58 PM