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... :/

 

[quicknote]

I have not personally used VBA in Excel, but I am familiar with the concept of declaring arrays as public. This allows the array to be accessed and modified by other modules or procedures within the same workbook. It can be a useful tool for organizing and sharing data in Excel. However, it is important to carefully check for any errors or mistakes in the code, as even small errors can cause issues when working with arrays. I would suggest double checking your code and possibly seeking assistance from others who have more experience with VBA in Excel. Collaboration and troubleshooting are important aspects of the scientific process, and can help you identify and solve any issues you may be facing. Keep working at it and don't be discouraged, as persistence and attention to detail are key qualities of a successful scientist.