2d array

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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
  10. 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...

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

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