Option Base error...

  • Thread starter Thread starter pmguerra
  • Start date Start date
P

pmguerra

Hi

I'm using Option Base 1 at the top of Module1.

However when I use the Filter function (with Include = False), the
lower bound of my array becomes 0...

I want it to be 1...

Why does this happen?

How do I overcome this?

Thank you for your help!
 
pmguerra

You can't. That will always return a zero based array and as far as I know
you can't change it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error with calling Format sub 7
Option Base and reading from Access 3
Excel VBA help: Text file formatting 19
Optional argument as Variant not acting like number 4
Option Base 1; how to also make auto-arrays set to base 1? 11
lastrow function help 6
Convert list to UPPER, lower & Proper cases. 21
Store range of values in an array 6

Back
Top