lbound

  1. B

    Lbound() to UBound() logic

    I am wondering if there was any sort of way to assign an array order. Example - If one of the values in the array matches a cell value then assign that to the number 1 spot in the array. Here is the particular methodology I am using. I do not want to hardcode and list out my entire array in the...
  2. 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...
  3. 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...
    • Forestq
    • Thread
    • lbound split split function split string ubound
    • Replies: 1
    • Forum: Excel Questions
  4. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top