lbound and ubound

  1. R

    Loop sheets using Array

    Team, I am trying to loop through an array of specific worksheets with in workbook which are in folder. sheet names may vary as per the request i have. I want the code with dynamic sheet names. Ex: if i want to loop through only 2 sheet.. let say i want to loop Sheets "Data" and "Matter", code...
  2. S

    Array question

    Hi, I have a simple question regarding arrays. According to the MSDN help, the first element of a 2D array is located at (0,0) MSDN Link https://msdn.microsoft.com/en-us/library/02e7z943.aspx But, in my code, if I do the following: Sub test2() 'Table with Header-A in Cell(10,10) '...
  3. R

    Convert string array to variant array, or "Array("111", "222")" to Array("111", "222")

    Folks: I used a method to create an array that is actually a string, and captured account numbers (text values) like this: [CODE] strArray = "Array("111", "222", "333")" [End CODE] But I want to convert it to a variant like: [CODE] vntArray = Array("111", "222", "333") [End CODE] so that I can...

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