2d array

  1. F

    How to make a "fill down" inside a 2D VBA array?

    Hi to all, I have an array like this below, for which I'd like to have a "fill down" like for first 2 columns. I know there is a way in a sheet doing "RANGE(myRng).FillDown", but how can be done manipulating the VBA array itself? Thanks for any help. Dim arr(1 To 11, 1 To 4) As Variant arr(1...
  2. A

    2D Arrays match with Column

    I have a 2D-Array and I want to look up for values in the column. arrDestination(0, i) = Name(i) (asdfg, csda, asdfg,zzz) arrDestination(1, i) = Values(i) (100, 50, 100, 60) My 2D Arrays contains the names and values. If my arrDestination Array match with Column A then I want to insert the...
  3. S

    UserForm ListBox with 2D Array and Match

    Relatively new with VBA and doing my best to learn it. I have a userform which has a listbox. To this I would like to add some type of Match function so that the listbox only displays the rows in which a certain value is displayed. For example, the project ID is displayed in Sheet1 cell B1. In...
  4. B

    Non-contiguous range into 2D array

    Hi gurus, Happy Friday! I am trying to find a quick to read a non-contiguous range into a 2D array without iterating over every element. Basically I'm trying to dump each area of the range into each column of the array without iterating over every element for the sake of performance. I was...
  5. D

    Incrementally Slicing 1D Worksheet Range Into 2D Array in VBA

    Hello, Fairly new to VBA and feel like this is out of my league. I want to slice a one column range in my excel worksheet every time the type changes (it's uniform so it will always be i.e. 3 iterations of a type) into a 2D array in VBA. I need it sliced precisely because I will be indexing...
  6. S

    A week of struggling to covert an ActiveSheet.comments collection into a 2D array

    Afternoon everyone, I'll try and keep this short and unambiguous. I have a spreadsheet with pupils names (rows) and the subjects (columns) they are struggling in (I'm a teacher). The final column counts the number of notes for each pupil (row). I did manage to write a quick subroutine that...
  7. A

    2D array lookup that can return multiple values

    Hello, I have a table of die numbers that correspond to another table of production numbers. I am looking to see if it is possible to automate the summing of the production numbers based on where the die numbers are. I will continue to use this in the future and don't want to have to sum the...
  8. T

    Looping through 2D array prints the same value issue

    I'm writing this VBA code that loops through a defined range and finds the filled cells within in, then it refers 5 different indexes to each cell, and to check if each cell is truly indexed with these values, I write my array to a worksheet. I can manage the loop to work and print exactly the...
  9. M

    Values not saved in a 2D array

    Hi guys! I have a text file that I want to extract information from. I'd like to get the quantity and the product name information and save it on a 2D array, here's my code: Dim temp_current() As String ReDim temp_current(1 To number_lines, 1 To 2) As String Open FileName(a, c, b) For Input...
  10. D

    Reorder 2D Array by time order

    Hi All, I have a 2D array where the first colum has a range of dates and the second colum has a range of numbers. I wish to reorder this array in time order. My attempts all seem to fail. Does anyone know of a way of doing so? Dim a As Date Dim b As Date Dim c As Date Dim d As Date a...
  11. S

    Paste all values of 2D array straight into worksheet possible?

    Hi all, I would like to transfer all my data from a 2D array into a worksheet straight away, without having to use for loops to transfer the data 1 by 1. Is that possible? Because it seems using the 1 by 1 method is taking really long to load a worksheet. excel 2007 Thanks Shie Boon
  12. D

    Report the value of an intersecting row and column, without numbering the row and column

    <TABLE style="WIDTH: 197pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=263><COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" span=3 width=64><TBODY><TR...

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