2d array

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

Some videos you may like

This Week's Hot Topics