+ Reply to Thread
Results 1 to 12 of 12

Scripting.Dictionary Question

Hybrid View

msolari Scripting.Dictionary Question 02-27-2013, 04:09 PM
Leith Ross Re: Scripting.Dictionary... 02-27-2013, 04:12 PM
msolari Re: Scripting.Dictionary... 02-27-2013, 04:15 PM
jindon Re: Scripting.Dictionary... 02-27-2013, 04:43 PM
Leith Ross Re: Scripting.Dictionary... 02-27-2013, 04:20 PM
msolari Re: Scripting.Dictionary... 02-27-2013, 04:28 PM
msolari Re: Scripting.Dictionary... 02-27-2013, 05:10 PM
JosephP Re: Scripting.Dictionary... 02-27-2013, 05:13 PM
msolari Re: Scripting.Dictionary... 02-27-2013, 05:16 PM
msolari Re: Scripting.Dictionary... 02-27-2013, 05:26 PM
jindon Re: Scripting.Dictionary... 02-27-2013, 05:32 PM
msolari Re: Scripting.Dictionary... 02-27-2013, 05:39 PM
  1. #1
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Scripting.Dictionary Question

    DXNRY(CStr(Range("F" & z))) = 1
    Let's assume the value of CStr(Range("F" & z)) = "x"

    The line is setting Item property of dictionary for "x" to 1
    In other words, it is equivalent to
    DXNRY.Add CStr(Range("F" & z).Value), 1
    It is not an Index, so 1 could be anything.

  2. #2
    Registered User
    Join Date
    09-19-2012
    Location
    Anaheim, California
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Scripting.Dictionary Question

    THANK YOU THANK YOU THANK YOU!!! You confirmed it. Been staring at this forever. Such a relief

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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