Option Base error...

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!
 
D

Dick Kusleika

pmguerra

You can't. That will always return a zero based array and as far as I know
you can't change it.
 

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
Optional argument as Variant not acting like number 4
Option Base 1; how to also make auto-arrays set to base 1? 11
Application.OnTime - Macro Cannot Be Found - Internet Explorer 0
Excel VBA help: Text file formatting 19
Permutations andText to column problem 6
Store range of values in an array 6

Top