+ Reply to Thread
Results 1 to 4 of 4

Can I reference a table in Excel VBA?

  1. 09-04-2013, 02:33 AM #1
    ExcelFailure
    ExcelFailure is offline
    Forum Contributor
    Join Date
    03-06-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    352

    Can I reference a table in Excel VBA?

    Morning,

    As the title really...instead of putting a range of cells in VBA can I somehow reference a table?

    Thank you
    Reply With QuoteRegister To Reply
  2. 09-04-2013, 02:37 AM #2
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Can I reference a table in Excel VBA?

    Yes you can... Just use a record macro and select the table which will show the table references in vba code.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  3. 09-04-2013, 02:44 AM #3
    ExcelFailure
    ExcelFailure is offline
    Forum Contributor
    Join Date
    03-06-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    352

    Re: Can I reference a table in Excel VBA?

    Of course. Thank you again
    Reply With QuoteRegister To Reply
  4. 09-04-2013, 02:46 AM #4
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Can I reference a table in Excel VBA?

    Glad it helps you and thanks for the feedback
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel table - using a formula in a structured reference
    By jankee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2013, 08:10 AM
  2. [SOLVED] Fixed Reference for a table like $ in normal excel
    By kenny.fsw in forum Excel General
    Replies: 6
    Last Post: 05-04-2012, 03:43 AM
  3. Excel 2007 : External table reference throws invalid cell reference unless source document is open
    By silverwyrm in forum Excel General
    Replies: 3
    Last Post: 05-13-2009, 11:51 PM
  4. excel conversion/reference table
    By udigold1 in forum Excel General
    Replies: 2
    Last Post: 07-07-2008, 07:46 PM
  5. [SOLVED] Where can I find a tax table (for reference) template for Excel?
    By monkshift in forum Excel General
    Replies: 0
    Last Post: 06-01-2006, 10:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1