Declaring global variables

**MikeFranz123** · 04-19-2012, 04:17 AM

Hi,

I'm trying to access a variable in sub 2 which was declared in sub 1, both within the same module. How do I do this i.e. I want to declare a variable in sub 1 such that its accessable in sub 1 and sub 2. I've tried declaring the variable as global above both subs (in the declarations section), but it doesn't seem to be working

Thank you!

**kieranbop** · 04-19-2012, 04:34 AM

example, enter this at the top of a general module (eg Module1).

Please Login or Register  to view this content.

Then refer to it in your worksheet event code as you would any other variable. For example.

Please Login or Register  to view this content.

hope this helps

**kvsrinivasamurthy** · 04-19-2012, 04:34 AM

In (General)declarations declare variable like this and try.

Please Login or Register  to view this content.

**Andy Pope** · 04-19-2012, 04:35 AM

You can't if the variable was declared in sub1. You would need to pass it into sub2 as an argument.
Or move the declaration outside of sub1 and have it available to all routines in the module.

If you declare the variable in sub1 AND outside of all routines the variables used in sub1 and sub2 will be different variables with different scope but with the same name.

**JosephP** · 04-19-2012, 04:36 AM

you can declare a module level variable that is used by both bits of code (but do NOT declare the same variable again in either code) or you can pass the variable from one routine to the other which is usually better

**MikeFranz123** · 04-19-2012, 05:52 AM

Thanks for the replies.

I'm not sure what I'm doing wrong, but I tried those suggestions and I'm not getting it to work. Here is a sample copy of my code:

Please Login or Register  to view this content.

And its throwing an error when I run sub temp, saying that object is required at the "consolidatedFile.activate" line

Any help would be awesome! Thanks!

**MikeFranz123** · 04-19-2012, 05:56 AM

Ok, no problem, I sorted it out. Thanks so much to everyone for their help, much appreciated!

**JosephP** · 04-19-2012, 05:57 AM

Originally Posted by MikeFranz123

its throwing an error when I run sub temp, saying that object is required at the "consolidatedFile.activate" line

that line ain't in the code you posted. if it's in your real code then the problem is that you're trying to use a string as a workbook.

**Andy Pope** · 04-19-2012, 06:01 AM

Please Login or Register  to view this content.

I assume you got it to work by running the other sub first.

Also I assume your example is contrived as I don't see the point of activating the activeworkbook.