arrays

Hey guys, im trying to fill up my array and extended whenever needed: arraySizeX = 1 arraySizeY = 2 ReDim Preserve orderArray(1 To arraySizeX, 1 To arraySizeY) orderArray(1, 1) = "test" orderArray(1, 2) = lastRow - 1 arraySizeX = arraySizeX + 1 ReDim Preserve orderArray(1 To arraySizeX, 1 To...

Hey guys, I'm trying to dodge making cycles to fill up my array, so i was hoping to just do this: lastRow = Cells.Find(what:="*", searchorder:=xlByRows, searchdirection:=xlPrevious).Row Set bigRange = Application.Union(Range(Cells(2, 3), Cells(lastRow, 3)), Range(Cells(2, 4), Cells(lastRow...

Hello all, I am trying to use arrays for the first time and I am flummoxed! Although the array seems to be populating when I write the values to it, any attempt to read those values fail as nothing is returned. Now I KNOW that this is my stupidity and I have checked and rechecked the code that...

Hello Mr XLers! This formula below only works when the date in my sales Tax Table matches the date in my materials date column. I need to be able lookup tax % with after 1/1/2019 which is the beginning date in my Sales Tax Table. Any help would be awesome! :confused::confused::confused...

99% of the questions on this group can be answered by anyone with zero VBA experience but with the willingness to spend a few of minutes googling around and trying out the code. This one is not. So please, I need help from someone who actually knows VBA, not newbies (like me) who need to get...

I am using an array to populate a ListBox. I understand how to create an array and use it to populate a listbox with items from the Jobs table. I also have a customer table. The Jobs table contains the CustID number. How would I approach replacing the CustID number with their name from the...

I have a couple of hundred rows that I want to vlookup and I have over 100 data tabels, when I change a combobox a couple of thousand formulas recalculate. And it takes a couple of seconds to recalculate and I am looking at ways to increase speed. Will it be faster do load every data table...

I've got an issue with how to pull out the sum product of a value (X) set based on the share of presence of A and B respectively. The main problem is that I can't actually see A and B explicitly as shown below. Instead I've got a reference that tells me that A runs from 11/4 to 12/30 and B runs...

OK, from all I've read passing an array from one sub to another is easy, but when I try to do it here the VBA Macro window pops open and my code stops. I have tried to read everything else out there that tries to address this but no amount of defining or deleting of `()` helps. Sub...

Dear all, I would like to know if there is a way to use functions on concatenated arrays? I have 2 ranges of cells in the Name Manager as follows: Array 1 =Sheet1!$A$1:$A$5,Sheet1!$A$7:$A$10,Sheet1!$A$12:$A$16 Array 2 =Sheet1!$B$1:$B$5,Sheet1!$B$7:$B$10,Sheet1!$B$12:$B$16 When I try to...

Hello, I been trying to figure this one out but I can't find a way to do it without using macros. In the "warranty" section, I want to be able to match the mode value with the list on column G. The difference is that the list will have hyperlinks to a downloadable format. Some of the values...

Hi , can anyone help me with below query. i have a collection of arrays. and i need to read the values. eg: Dim resColl As New Collection resColl.Add Array(key, Key3("UserName"), Key3("Password")) in above add method i added arrays with 3 elements. and after adding i need to read the...

Hi All, Please anyone help me on below request. I'm working on Automation Dashboard Please help on below Code PositiveScr = WorksheetFunction.CountIfs(Sheets("CSAT Data").Range("F:F"), "9", "10", Sheets("CSAT Data").Range("H:H"), "AMER", "EMEAR", Sheets("CSAT Data").Range("E:E") ">=1/12/2019"...

Hello everyone. I have some custom defined VBA classes and no idea why they keep causing Excel to crash. My classes define objects. I use instances of those objects in dynamic arrays. I can't use collections because I need to edit the objects in the arrays and swap out the entries in the...

I am attempting to pull data into 3 arrays. 2 arrays from sheet one, "Summary", and 1 arrays from sheet two, "Detail". After pulling the arrays, I will compare Array1, "Project Name" on sheet Summary to Array3, "Project Name" from the detail Sheet. If the values match, I need to take he...

I have a workbook with a rather complex set of vba UDFs used to perform thermodynamic flash calculations. Multiple vba routines are called for each udf call. There may be +100 individual UDF calls within a work book across multiple sheets. Many of these will be interlinked with functional...

I'm working on a linear regression sub that creates a model equation to predict data points and I've reached a standstill in my project as I cant seem to find a pathway to merging the six 10x1 arrays into a single 10x6 array in order to perform a series of matrix manipulations using the 10x6...

I have read the threads about array formulas and I have tried that approach to my problem but it is not working for me. Even doing CSE on each cell and then F9 when data is changed is not working, so I gave up on that, and am now writing my own VBA. I have the VBA function (Median_No_Zeroes)...

I'm trying to create a new array from a larger array that has 4087 rows and 19 columns. I cycle through the main array to count the number of records matching the year 2017 of which there are 714. So my new array will be 714 rows by 11 columns. Most of the undernoted code works including the...

<tbody> </tbody> In my example I've got components of 5 combinations in B5:C9 to be multiplied, Extra is added to each of the B5:B9 and C5:C9 array(s) when calculating the Largest product of those arrays. Instead of listing the results of the multiplication I'd like their...