ubound

What is the functionality of UBound in for loop for the below code. x = wsPlan.Range("A1").CurrentRegion.Value Set Plan = CreateObject("Scripting.Dictionary") For i = 3 To UBound(x, 1) For j = 2 To UBound(x, 2) Plan.Item(x(1, j) & x(2, j) & x(i, 1)) = x(i, j) Next j Next i

I am trying to build this array that can be different for each set of data that is consantly growing. This means that I need to have a Ubound that is also growing. Unfortunately when trying to use the counter method to determine how big the Ubound should be everytime I kepp getting an error...

Hi, I have been fiddling with this logic, but I can't seem to make it work. Basically I just want to transpose arrays with varying lengths using the Ubound property. Here is the original code: Set rng = Range("VBAOutput") rng.offset(0, 229).Value = Application.Transpose(array) THANKS

Hi, I have an array that is xx(1 to 121, 1 to 121) as double and I want to paste the array to the worksheet. So I did... Range("DM2:IC123").Value = xx But what if the size of xx changes? Is there a way to automate the output maybe using the ubound? I'm thinking I would have to set a...

I'm looking for some help converting code from array to non-array. I was using Lbound to Ubound with the array. Can you please help adjust this code so that it works in this new format? Thanks for your help with this. If sh.Name = "Closer" Or sh.Name = "Mario" Or sh.Name Like "Fin*" Then...

Hi All I'm back begging for help again. Keep getting run-time error message when i get to the "convert values to a vertical array" part below in Red. Can anybody see where i'm going wrong please. it should be making a list of request numbers for a combobox in a userform so i can update...

Hi there, I have been looking for an answer to this question and didn t find the answer I was looking for. Let s consider the 3D array with the following dimension: Array(A,B,C) I call a1 the first slice of my cube I call a2 the second slice of my cube, and so on I call b1 the number of rows...

Hi, I am not sure if I am doing this right but here is the thing: > I have a list of transaction ID-ed from 1 to 30 > Each of the transaciton is a type P, D, G respectively for Purchased, Debited and Gifted > P and G are credit transactions > When the type is D, the oldest credited transaction...

Hi Guys, I am working to create a code that will take a worksheet containing a list of students and their associated test scores, generate a tab for each student and then copy and paste their test scores into that tab. The code that I have now will generate the tabs and copy/paste the headers I...

Hi Forum, I don't understand the code below, wondering if you could help explain it to me?:confused::confused: 1) What is the code looping? 2) What is the value of UBound(brr, 2) and UBound(arr)? 3) in Cells(s, 3).Resize(x, 1) = arr(i, 1), what does the = arr(i, 1) do? 4) in Cells(s...

Hi I'm amending some code written by a colleague who's now left. The code is used to change the column order of some data in excel and the column headers are contained within an array in the code. I've added 1 extra header in to the array but when I run the code it's now doesn't re order all...

Hi, in filed I have couple of value separated by comma like below: <tbody> A1 header1 B1 header2 C1 header3 Audi 592035, 579733, 653749, 579735 20 000 </tbody> If my macro found that string (always will be separate by ",") should split the string and add rows (= to number of...

I can do this but it would be long than it should be. Each cell is semi-colon delimited and I could change it to a comma or anything. The problem is that the child must have all the same properties as the parent plus the values of the child and I thought a UBound would work. like this: Code...

Hi, I'd like to find a way (trick) to exceptionally call a VBA build-in function that is overwritten with a custom function. Excel 2010 64bit For instance if I want to write my own UBound function with the same name, but in that function be able to call the VBA build-in function UBound...

I admit that UBound is the one command that I use that I do not understand but it has worked consistently for years. I upgraded to Windows 8 last week and today for the first time I found that this command is not working. BadQueryList = Array("spider", "MyBackyardFurniture", "Teak Yard...

Hi, I have a macro, that my Book2 fetches datas from reference workbooks Book1 and Book3. If i write to for loop 10 instead of 3, the code looks for Book4 to Book10, and just because this workbooks don' t exist in my path, the code gives an error eventually. Is it possible to ignore this...

Hi.. I have defined vAry as a Variant. I ReDim this to have 2 columns: ReDim vAry(330,38) How do I use Ubound on the second column only (the 38 element column)? I am trying to use a For loop but only on the second column. For I = 1 to vAry(???) This this possible? If I code...

I have populated a variant that is initially 1D from a worksheet using the Range.Value function. By the Split function this array then become a jagged array leaving me with an array like: <table border="0" cellpadding="0" cellspacing="0" width="107"><tbody><tr style="height:15.0pt"...

Hi All, I could use some advice on this issue. Been combing this over for a couple hours now and I can't seem to find out why it's giving me this error. Perhaps I'm stubborn, as I can probably make this work another way, but I can't help but try this as a more efficient method. I'm trying to...