To Global or not to Global

[dugdugdug]

I use some of my variables in more than one module.

In Module1, I have declared:

Sub Proc1

Dim wsg As Worksheet
Set wsg = Worksheets("Graph")

End Sub

In Module2, I do the same when I want to use it.

Question is, would it be better to declare wsg as a Global variable or not?

Does it save time / memory or is it negliable?

Thanks

 

[nuked]

As you're just referencing a spreadsheet object in memory, in this case a graph, then there is not a lot of point in maintaining a global pointer to it.

You would only consider making a variable global if it was a custom-object that needed maintaining between procedures, or, any sort of value-type that again was not already available from the spreadsheets.

 

[dugdugdug]

As you're just referencing a spreadsheet object in memory, in this case a graph, then there is not a lot of point in maintaining a global pointer to it.

You would only consider making a variable global if it was a custom-object that needed maintaining between procedures, or, any sort of value-type that again was not already available from the spreadsheets.

But I have other examples where I have declared in a module:

Global myarray() As Variant

because I use myarray() in several modules.

So should that also just be declared in the declaration section of a module simply as Dim myarray() As Variant instead of globalling it?

 

[nuked]

If you need to use the contents of myarray() elsewhere then yes. If you just want to re-use the structure, then no. Just declare it again.

 

[dugdugdug]

If you need to use the contents of myarray() elsewhere then yes. If you just want to re-use the structure, then no. Just declare it again.

Thanks