Greeting All!
The Excel program I work with uses many worksheets and many ranges; most of these ranges are used repetitively, thus I am setting these sheets & ranges as variables throughout my code.
I recently read where a coder, in addition to declaring his variables as public also 'Set' them in the Workbook Open event.
I as well have mine set as 'Public' but I am wondering from a technique and/or speed perspective is it a good idea to 'Set' your variables in the Workbook Open Event or just set them at the beginning of each event and then unset them at the end of each event?
Or...is there a better way altogether not mentioned here.
Thanks...
The Excel program I work with uses many worksheets and many ranges; most of these ranges are used repetitively, thus I am setting these sheets & ranges as variables throughout my code.
I recently read where a coder, in addition to declaring his variables as public also 'Set' them in the Workbook Open event.
I as well have mine set as 'Public' but I am wondering from a technique and/or speed perspective is it a good idea to 'Set' your variables in the Workbook Open Event or just set them at the beginning of each event and then unset them at the end of each event?
Or...is there a better way altogether not mentioned here.
Thanks...