Results 1 to 16 of 16

Dictionary or Scripting.Dictionary. Binding Referencing Dim-ing. Sub routines and Function

Threaded View

Doc.AElstein Dictionary or... 07-12-2016, 04:48 AM
xlnitwit Re: Dictionary or... 07-12-2016, 05:49 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 07:37 AM
xlnitwit Re: Dictionary or... 07-12-2016, 05:58 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 07:38 AM
xlnitwit Re: Dictionary or... 07-12-2016, 07:54 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 08:00 AM
xlnitwit Re: Dictionary or... 07-12-2016, 06:01 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 07:39 AM
xlnitwit Re: Dictionary or... 07-12-2016, 06:06 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 07:39 AM
xlnitwit Re: Dictionary or... 07-12-2016, 07:58 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 08:15 AM
xlnitwit Re: Dictionary or... 07-12-2016, 08:02 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 08:28 AM
Doc.AElstein Re: Dictionary or... 07-12-2016, 07:49 AM
  1. #15
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Dictionary or Scripting.Dictionary. Binding Referencing Dim-ing. Sub routines and Func

    Quote Originally Posted by xlnitwit View Post
    ..... but the difference between Dictionary and Scripting.Dictionary is the same as that between Range and Excel.Range
    It is preferable to use the full class identifier to avoid any potential confusion with other objects of the same name, such as Word's Range object.
    Yes, that does make sense. Generally Ido not rely on the Implicit Defaults, which the original OP code I had was .. probably... the OP has no idea what as Implicit etc... is lol.. bless him : )
    That may help explain a bit the intellisense discrepancy... I guess there may be other Dictionary 's - which was my original concern was that I may have been accessing with .Dictionary
    something other than the
    Scripting.Dictionary,
    _.. which you have confirmed that i am not.

    You have been very helpful in me getting this very clear in my head

    Great and quick help
    Thank you again
    Alan
    Last edited by Doc.AElstein; 07-12-2016 at 09:31 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Scripting dictionary help
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2016, 09:32 PM
  2. [SOLVED] VBA Scripting.Dictionary Code Late Binding Error
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 07-20-2015, 03:06 AM
  3. Scripting dictionary help
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-14-2014, 09:51 AM
  4. need help with scripting dictionary
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 10-04-2014, 04:33 PM
  5. [SOLVED] Using Dictionary in VBA scripting
    By vnzerem in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-04-2014, 02:54 PM
  6. Scripting Dictionary
    By Tendla in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2013, 05:41 AM
  7. [SOLVED] Scripting Dictionary help
    By williams485 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-13-2012, 08:22 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1