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!