Anyone use VBA in Excel: eclaring Arrays as Public

[Saladsamurai]

Anyone use VBA in Excel::Declaring Arrays as Public

Egads man...I have seen plenty of modules with arrays declared as Public. Clearly I am making some boneheaded error here and cannot locate it:

Any Thoughts?

 

[Saladsamurai]

Solved:

After some searching I found that the error is because I wrote my code in a sheet and not a module... :/