Anyone use VBA in Excel: eclaring Arrays as Public

  • #1
3,003
2

Main Question or Discussion Point

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:

ExcelError.jpg


Any Thoughts?
 

Answers and Replies

  • #2
3,003
2


Solved:

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

Related Threads on Anyone use VBA in Excel: eclaring Arrays as Public

  • Last Post
Replies
5
Views
3K
  • Last Post
Replies
8
Views
7K
  • Last Post
Replies
18
Views
4K
Replies
4
Views
5K
  • Last Post
Replies
1
Views
2K
Replies
2
Views
3K
Replies
2
Views
2K
Replies
3
Views
6K
Replies
1
Views
54K
Top