array dimension

  1. M

    Dim Elements of Array

    If I dimension an array, DataArray(50,5) as variant, I wish to have each of the 5 elements of the second dimension have certain types other than Variant. For example, the 1st element should be a string. The second should be Double, the third long, the fourth String and the 5th long. Someone...
  2. G

    multidimensional arrays

    Hi all, I've got 2 related questions: (1) I am trying to define a two-dimensional array. The size of the array will vary somewhat, and each element of the array will have 3-5 subelements (overall, probably 75x5 max). Is there a way to build an array that flexes in size like that? Right now I'm...
  3. P

    Find a value within a 2D array

    Hi all, I have an array formula that finds the minimum difference between a value (stored in E5) and a 2D array of values (stored in another sheet, Database2!B5:U25). The array formula I used is as follows (entered with CTRL-SHIFT-ENTER): =MIN(ABS(Database2!$B$5:$U$25-E5)) This gives me the...
  4. J

    Create as many levels of a loop as there are dimensions of a string

    *Edit* sorry the title should have been: Create as many levels of a loop as there are dimensions of an array Sorry for the confusion! --- Hi, This is somewhat difficult to explain, but please look at the following UDF: Public Function ConcSep_Array(InArray() As Variant, Optional Sep As...

This Week's Hot Topics

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
Top