Can you make an array a global variable? Let's say I have an array of Dates that run from 2000 to 2050 and I fill this array at the beginning of my program. Will all the subs and functions have access to this Dates array? I've tried this out over and over again but I can't seem to get it to work so I have to refill the Dates array in each sub and/or function that needs this info. Am I doing things wrong or is there a limitation in VBA that makes it so arrays can't be global/public?