Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Anyone use VBA in Excel: eclaring Arrays as Public

  1. Nov 17, 2009 #1
    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?
     
  2. jcsd
  3. Nov 17, 2009 #2
    Re: Anyone use VBA in Excel::Declaring Arrays as Public

    Solved:

    After some searching I found that the error is because I wrote my code in a sheet and not a module..... :/
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: Anyone use VBA in Excel: eclaring Arrays as Public
  1. Excel macro's and VBA (Replies: 18)

Loading...