Locals Watch Disappears; Program Crash

  • Hi,
    I'm in the process of writing/editing a macro, but after I run the macro once, the Expressions in the Locals Watch window disappear, and if I try to run it again it produces an "Excel has encountered an error and needs to close".

    The macro probably doesn't make much sense out-of-context, but perhaps there's a glaring error that's causing this ...
    A guess - possibly related to the Error Handling in the vba? (1st time I've used this in a macro).

    Any ideas/advice anyone?

    Basically, I've got two sets of data on different sheets, with NASP ID and country being variables. Just trying to import the data from the 'Comparison' sheet, if both the NASP id and country matches that on the first sheet, established by the variables.

    Thanks for any advice.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!