option base

  1. J

    Creating an array from a range and keeping the 0 row/column

    This may not be expressed well, but... I want to create an array from a large range (changes depending on the data but let's say A1:Y7000). This is easy enough with something like dim rg as range set rg = range("A1:Y7000") Dim arr() as variant arr = rg However, I want column and row 0 and...
  2. T

    Option Base 1 is not working

    Hello all you MrExcel experts To try to better familiarize myself with arrays, I set up the following simple macro using Windows 10 and Office 365. You will notice that I have commented out the command of ‘Option Base 1’. With this done, and I run the macro, I get the word ‘for’ displayed...

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