| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error on new Data Base Query | Excel Discussion (Misc queries) | |||
| Option Commands (Option Explicit / Option Base etc) - Scope | Excel Programming | |||
| Error Checking Option | Excel Programming | |||
| Option Base and reading from Access | Excel Programming | |||
| Option Explicit Error | Excel Programming | |||
![pmguerra[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
