I get this error ['1004' Method Range' of Object _Worksheet' Failed] when try to run

  • Hi All,


    I need to print tables from ranges where the SubTotal is not equal to zero.


    I get a Run-Time Error ['1004' Method Range' of Object _Worksheet' Failed ] when I try running the code below.
    It was working ok, but I needed to add a portion in blue to reference the right Print Areas...
    Any help welcome as I'm feverishly working on this file. Thank you, thank you.


  • Re: I get this error ['1004' Method Range' of Object _Worksheet' Failed] when try to


    You have a lot of invalid ranges in there. For example 138a is not a valid cell address, or range name.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

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