W WhytheQ Apr 15, 2008 #1 Good Morning, Quick question: Does Option Base 1 work within a class module? Regards JasonQ.
P Peter T Apr 15, 2008 #2 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
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
W WhytheQ Apr 15, 2008 #3 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 - Show quoted text - Click to expand... 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/micr...f5/74e463980a4bed23?hl=en-GB#74e463980a4bed23 Should I wrap it up in an add-in? or is there an easier way for several workbooks to reference a common class ? Jason.
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 - Show quoted text - Click to expand... 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/micr...f5/74e463980a4bed23?hl=en-GB#74e463980a4bed23 Should I wrap it up in an add-in? or is there an easier way for several workbooks to reference a common class ? Jason.
