Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using XL 2003.
I generally set Option Base 1 in my projects, as a personal preference (MS gave us the option, so I'd think either way is ok). However, even in Option Base 1 project, some arrays don't start with 1, such as: Option Base 1 Sub testme CArray = Array(1,2,3,4) Msgbox CArray(1) 'returns a value of 2 End Sub Is there a way to ensure that these 'on the fly' arrays also start with Base 1, or am I stuck with having mixed array types if I assign these arrays on the fly? Thanks! Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Option Base error... | Excel Programming | |||
Can you Auto fill address in excell with a data base? | Excel Worksheet Functions | |||
Option Commands (Option Explicit / Option Base etc) - Scope | Excel Programming | |||
Knowledge Base 247412 need help to make work | Excel Programming | |||
Option Base and reading from Access | Excel Programming |