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

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

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

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

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

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

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

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

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

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

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