+ Reply to Thread
Results 1 to 4 of 4

Refer to dictioanry created on listobject

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Refer to dictioanry created on listobject

    Hi,

    Please Login or Register  to view this content.
    i am trying to get the value from column table with header "Sheet Name Output" or to whole range as item using dictionary created on listobject.

    This is not working.
    Please Login or Register  to view this content.
    Why?

    Best,
    Jacek
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Refer to dictioanry created on listobject

    Not sure what you are doing, but don't you want all this after the For-Next code block and not within it.

    Please Login or Register  to view this content.

    EDIT:
    As an afterthought, this string doesn't exist in the dictionary Items because it's never a cell value.
    "1-Vn_Input_Tiers[Group]"
    Last edited by AlphaFrog; 12-12-2018 at 10:39 AM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Refer to dictioanry created on listobject

    Hi,

    thank you.

    goal is to assign to key not one single item but range from listobject.

    And to output it using key.
    And output only once cell within item range also.

    Best,
    Jacek

  4. #4
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Refer to dictioanry created on listobject

    okey,

    stupid issue, i creating no ending loop in function and this was a problem...:/

    Sorry,
    I am closing topic,
    Best,
    Jacek

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy filtered column of ListObject to another ListObject
    By snapfade in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-15-2016, 04:00 PM
  2. Can you refer to ListObject Rows by "name"?
    By shawnvw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2015, 06:42 PM
  3. Refer to just created workbook automatically
    By IKZOUHETNIETWETEN in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2014, 07:22 AM
  4. [SOLVED] Refer to a combobox not created in a userform in VBA
    By Hugo-F in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-22-2013, 04:33 AM
  5. Replies: 2
    Last Post: 03-26-2013, 08:06 AM
  6. Click events on buttons created at runtime only work on the last button created
    By Treacle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2010, 05:44 AM
  7. [SOLVED] How to make List created refer by another worksheet data?
    By Agung Widodo in forum Excel General
    Replies: 1
    Last Post: 05-12-2005, 12:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1