Results 1 to 7 of 7

Add & calculate Values in Scripting.Dictionary

Threaded View

  1. #1
    Registered User
    Join Date
    12-05-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    11

    Add & calculate Values in Scripting.Dictionary

    Dear Experts,
    Please refer the attached excel file.
    With the help of existing VBA codes, we are trying to derive no. of combinations for given sizes & then some calculations are made.

    If there are many sizes or the smaller sizes are there then the no. of combinations reaches to some thousands / lakhs.

    To reduce the time is it possible (instead of populating the data in excel cells with given VBA codes) to make all the entries & calculation in Scripting.Dictionary then just paste the data as shown in attached file.

    Please suggest.
    Thanks in advance....

    Add in Directory.xlsm
    Last edited by girish.talele; 12-17-2012 at 08:28 AM. Reason: more clarification about the problem

Thread Information

Users Browsing this Thread

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

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