Microsoft Office Forums - View Single Post - [Solved] Best way to make variables in one sub available to a called sub

Jennifer Murphy · 02-29-2020, 12:18 AM

Quote:

Originally Posted by macropod

Any variables you declare at the top of your code module (i.e. before any subs) will be available to all subs in that code module. See, for example: https://www.msofficeforums.com/148491-post2.html

That's what I surmised.

After playing with that a bit, I decided to pass the variables I want the Sub to change with ByRef and the rest with ByVal. It's working now and I think it's more readable code. All of my declarations are together in the main Sub and it's clear what the sub Sub is working with.

Thanks.