option base 1

  1. wsnyder

    Option Base 1 But LBound Is 0

    Hi all, Using Excel 365. I have Option Base 1 at the top of my Modules However my code is returning Subscript Out of Range error And when I hover over the array variable for LBound it shows as 0. thanks, -w Error here: Debug.Print vCriteria(i), vColumns(i) Full code: Option Explicit...
  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...
  3. W

    How to get rid of Option Base 1

    How can I get "Option Base 1" out of Module and into function "Date_Hijri_Greg" I tried some things with Lbound and Ubound but was unscuccesful Perferably I'd like the isLeapH(N) into function "Date_Hijri_Greg" as well leaving only one function Option Base 1 Public Function isLeapH(N) As...

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