Run-time error '1004'

  • Hello all,

    I am getting a "Run-time error '1004'" (application-defined or object-defined error when trying to run the following script:

    Apparently, the problematic script is the: Sht1Rng = Sheets(1).Range("A1", Sheets(1).Range("A1").End(x1Down))
    Can anyone help me understand what is wrong here?

  • thanks Jon.

    I changed the 1 to an l but now i get a run-timer error '91' object variable or With block variable not set. Where the corrupt script still resides in the Sht1Rng line of code.

Participate now!

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