array elements

  1. R

    Array Elements

    Hi. I am trying to determine how many elements are in arrays. Say I have an array that I created (Variant) with the following: Redim Array1(2) To me, this is an array with one element. If I create an array with the following: Redim Array1(0,2) To me, this is an array with multiple...
  2. P

    How to input a column(50x1) of a stored array(50x50) as an input to a function??

    I have an array of 50x50 size. The array is stored and is not displayed anywhere on the spreadsheet. I need to give the columns(50x1) one by one as input to a function. What is the quickest way of doing this using VBA? Please help me!
  3. R

    Checking Array Elements

    Hi... I have a Variant Array, Dim vArr as Variant I split into the array a field from my spreadsheet that may or may not contain a value that I am finding. My example: ReDim vArr(5) vArr = Split(Sheets("Master Schedule").Cells(i, 11), ";") I then move each element into another array...

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