VBA

Dan

When you declare a variable as Public in a module this variable can be seen and shared by any project(workbook) open at the time.

However you should limit the use of these global variables(Sharing variables with other worksheets).

Global variables are very hard to keep track of, and you never know when another routine is using that value without careful tracking, which could take time and effort especially if there is a bug.

Hope this helps

Carlos