VBA: Public variable not carrying between modules (help!)

[hellfire45]

Hi guys,

So I have some VBA. I am declaring a public variable as integer in module 1 and lets say for example in module 1 it is declared as a value = 19.

Public batch_audit_col As Integer

batch_audit_col = Application.Match("BATCH1", Dash.Rows("1:1"), 0)

Then module 2 starts and I do not re-declare it and I apparently don't need to because VBA Doesn't error and ask me to. So I expect the value will still be 19. However, its not, its equal to zero. Not blank, but zero.


So if I hit a break point in the code and check the value of the variable in each module module 1 will say 19 and module 2 says 0. I need both modules to know that the variable is equal to 19.



Why is this happening? Thanks for the help.

 

[Nine Zero]

in module 2 try calling it with the sub name so for example

Module1.batch_audit_col

 

[hellfire45]

interesting suggestion!

This didn't work though. It's still coming up as 0.

 

[Fluff]

Double check that you are re-declaring it anywhere (including in code) & also check that you are not re-assigning a value

 

[Joe4]

Double check that you are re-declaring it anywhere (including in code) & also check that you are not re-assigning a value

A good way to do that is to use the built-in Find functionality (CTRL-F), and search for that variable name across the "Current Project".
It should then cycle you through all instances of that word appearing in your code.