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...
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...
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.
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...
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...
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...
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...
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...
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
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.