wageslave101
Board Regular
- Joined
- Jul 18, 2007
- Messages
- 154
Cleaning up a Project and there are lots of the modules attached that constantly reuse the same variables over and over.
Can I declare these once, so that the every module can use these or must they be declared seperately?
For example every module in project starts with;
Seems somewhat redundant to me to delcare these in every single module within the project when they remain the same the entire time.
Thank you very much for your time,
WageSlave101
Can I declare these once, so that the every module can use these or must they be declared seperately?
For example every module in project starts with;
Code:
Sub Start()
Dim RepName As Variant
Dim RepLocation As Variant
...lots of others
RepName = Workbooks(ThisWorkbook.Name).Worksheets("RepData").Range("A1").Value
RepLocation = Workbooks(ThisWorkbook.Name).Worksheets("RepData").Range("A2").Value
... lots of others
End Sub
Seems somewhat redundant to me to delcare these in every single module within the project when they remain the same the entire time.
Thank you very much for your time,
WageSlave101