dictionary class

  1. M

    VBA: Find and Group All Occurrences of Value, Run Sub, Move to Next Group

    Hi, I need some help getting started on a code. I have a range ("B4:B") of variables that are related by the first four characters (the year). Currently an input box will appear asking which year to run the code in, and the default value is based on the left four characters of the active cell...
  2. J

    VBA Dictionary

    I was helped here a while back to create some code to look at each cell in column C of Query that is equal to a cell in column C of SC. SC values show up multiple times in Query, so it loops through until the values either don't match and column G is blank or an instance is found and the value...
  3. D

    Change VBA code for Mac compatibility

    Hi, I got the following code thanks to MickG here on this forum, which helped me a lot! It worked on Excel on Windows, but on the Mac, where it's gonna be used, it doesn't.. I imported the Dictionary.cls and KeyValuePair.cls from https://sysmod.wordpress.com/2011/11...ng-dictionary/, but I...
    • ddewilt
    • Thread
    • compatibility dictionary class keyvalue mac 2016 macro
    • Replies: 7
    • Forum: Excel Questions
  4. bernatbosch

    Add a dictionary class to substitute the “Microsoft Scripting Runtime” dictionary

    Hi guys, and excuse my English (I write from Barcelona) I do work with Excel for Mac 2011. Excel for Mac users do not have the reference to the “Microsoft Scripting Runtime” dictionary (scrrun.dll) and I though it would need a dictionary for one of my vb projects. So, I did a little research...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top