Can I declare a variable for the entire project?

[wageslave101]

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;

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

 

[Tom Urtis]

I showed you an example of just that in your post here:
http://www.mrexcel.com/board2/viewtopic.php?p=1391136

Declare the variables once as Public, at the top of a standard module such as in that link.

 

[wageslave101]

Thanks Tom

 

[Richard Schollar]

Hi

Yes you could declare them as Public in the declarations section of a module (in fact you could use a separate module just to store your Public variables):

'at top of your module before any subs/functions
Public RepName As Variant
Public RepLocation As Variant

Note that Public variables will retain any values assigned to them in that Excel session (so if you want to use the variable in another sub but don't want any old value, then you need to specifically initialise the variable with a new value).