ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Option Base 1 in class module (https://www.excelbanter.com/excel-programming/409381-option-base-1-class-module.html)

WhytheQ

Option Base 1 in class module
 
Good Morning,

Quick question: Does Option Base 1 work within a class module?

Regards
JasonQ.

Peter T

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.




WhytheQ

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.


All times are GMT +1. The time now is 07:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com