Option Base error...
 

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
------------------------------------------------------------------------
pmguerra's Profile: http://www.excelforum.com/member.php...o&userid=14986
View this thread: http://www.excelforum.com/showthread...hreadid=532078

Option Base error...
 

pmguerra

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

--
Dick Kusleika
MS MVP - Excel
www.dailydoseofexcel.com

pmguerra wrote:
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!