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..... :/
     
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook