associative array

  1. E

    VBA to find the associated cell to another one which is in a different worksheet

    Dear all, I have something tricky to do in VBA and since I just started on this malarkey, I am a bit lost. My actual macro calculates what is called "Min.DR". This is calculated based on trends in sheet "QLT_SS_Input" (steady state cases). The min DR is then copied into the output tables...
    • Ealglez
    • Thread
    • associated data associative array find & return worksheet change
    • Replies: 0
    • Forum: Excel Questions
  2. S

    Dictionary Object: Add range OR array as an item to a corresponding key?

    Hi Guys, can I add a range or an array as an item to a corresponding key? Lets say I have a spreadsheet where Column A has values that populate my dictionary Keys and columns B:D contain the item. So if I used the "Add" method,it would look like this: D.Add Key:=Value Item:Values in the row...

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