How to get the Option Base?

    Hello,


    Do not know how familiar you are with Excel ... but, in this case, you will need VBE ...


    with a library called : Microsoft Visual Basic for Applications Extensibility


    Chip Pearson has an excellent explanation :


    http://www.cpearson.com/excel/vbe.aspx


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    From what I understand, this allows the use of the "Find" method, which looks in my VBA code if I wrote "Option Base 1" at the top. It is an alternative to reading (and I do not know if this allows changing the value), but I wanted something more straightforward like Application.<...>.Base. Anyway, thank you.

    There isn’t a property for that. Why would you need to know that at runtime?

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login