Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Base 1 in class module
Good Morning,
Quick question: Does Option Base 1 work within a class module? Regards JasonQ. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Base 1 in class module
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
|
|||
|
|||
Option Base 1 in class module
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 | |
|
|
Similar Threads | ||||
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 |