Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good Morning,
Quick question: Does Option Base 1 work within a class module? Regards JasonQ. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sure, why, did you get something different when you tested it.
Of course LBound of some resultant arrays is always zero irrespective of Option Base, Split for example. Regards, Peter T "WhytheQ" wrote in message ... Good Morning, Quick question: Does Option Base 1 work within a class module? Regards JasonQ. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On 15 Apr, 10:57, "Peter T" <peter_t@discussions wrote:
Sure, why, did you get something different when you tested it. Of course LBound of some resultant arrays is always zero irrespective of Option Base, Split for example. Regards, Peter T "WhytheQ" wrote in message ... Good Morning, Quick question: Does Option Base 1 work within a class module? Regards JasonQ.- Hide quoted text - - Show quoted text - Thanks Peter. Didn't realise that the scope of Option Base 1 was only modular. Are you able to help with a different query I have about class modules: http://groups.google.com/group/micro...e463980a4bed23 Should I wrap it up in an add-in? or is there an easier way for several workbooks to reference a common class ? Jason. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
Class Module vs Normal Module | Excel Programming | |||
Option Base 1; how to also make auto-arrays set to base 1? | Excel Programming | |||
Option Commands (Option Explicit / Option Base etc) - Scope | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |