BBHRVS
Board Regular
- Joined
- Nov 3, 2005
- Messages
- 94
Hi;
I am using in all the macros of a workbook abbreviations for the worksheets.
Since then, at the beginning of each macro, there was something like :
Set wsh1=Thisworkbook.Worksheets("name1")
Set wsh2=Thisworkbook.Worksheets("name2")
...
I want now to define only once the abbreviations of the worksheets and be able to use them in any macro of the procedure.
I tried with a public sub, but this does not work properly.
What is the correct way to do it ?
I am using in all the macros of a workbook abbreviations for the worksheets.
Since then, at the beginning of each macro, there was something like :
Set wsh1=Thisworkbook.Worksheets("name1")
Set wsh2=Thisworkbook.Worksheets("name2")
...
I want now to define only once the abbreviations of the worksheets and be able to use them in any macro of the procedure.
I tried with a public sub, but this does not work properly.
What is the correct way to do it ?