none
Runtime error 32809 Application or object defined RRS feed

  • Question

  • My code is used by six different remote sites [exact same code]. I made some changes to the code, export the changed modules to a file which is then imported in the various site's program. Before I sent the code to the user I run a test to ensure there's no problems. I've being doing this for some time without any hazels. No suddenly I get this message on some of the sites at different areas of the code. For instance this is some part of my code:

    If ActiveSheet.name = "ABC" then tSer [public decl as long] = 5

    If ActiveSheet.name = "DEF" then tSer = 6

    If ActiveSheet.name = "GHI" then tSer  = 7

    I get the error on the first line [ABC]. My limited VBA knowledge tells me even if sheet ABC does not exits, the code should   do the next test?

    Any assistance would be much appreciated! I search for error code 32809 - No results.

    Tank you

    Wednesday, February 4, 2015 4:02 AM

Answers

All replies