ubound

  1. V

    Functionality of UBound in For loop

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

    Ubound Defined by Variable in Array

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

    transform array of varying lengths

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

    output 2d array in vba

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

    VBA Convert from Array to Non-Array

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

    Run-time error '13': Type mismatch

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

    Ubound multidimensional array

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

    Multidimensional Array - Upper and Lower bound

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

    Transferring Data from worksheet to tabs based on tab name

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

    Seek UBound and Loop Code Explanation

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

    VBA Arrays - unable to change array size

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

    split string separated comma

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

    Can I use UBound for delimited cells?

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

    How to call build-in function that is overwritten with same name?

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

    UBound(Z) has worked for years but the only thing that changed is Windows 8

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

    Do While? Or LBound Ubound?

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

    Ubound with Muliple Columns

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

    Loop through Jagged Arrays?

    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"...
  19. D

    Efficienct Array Input Error?!?

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

Some videos you may like

This Week's Hot Topics

Top