• Prevent Named Range Change Whn Row Deleted? (2000 sr1 sp3)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Prevent Named Range Change Whn Row Deleted? (2000 sr1 sp3)

    Author
    Topic
    #384724

    Does anyone know how to prevent Excel from changing a named range
    when an included row is deleted (or added)? What I have is;
    Data =Sheet1!$B$1:$U$10
    and if I delete row 3, it changes to:
    Data =Sheet1!$B$1:$U$9
    I would like for it to not change at all…..

    Thanks…. Robbie

    Viewing 0 reply threads
    Author
    Replies
    • #660992

      Data=INDIRECT(“Sheet1!$B$1:$U$10”)

      Steve

      • #662057

        Thnks Steve,

        That worked perfectly. Don’t know how I overlooked it!!!

        Robbie

    Viewing 0 reply threads
    Reply To: Prevent Named Range Change Whn Row Deleted? (2000 sr1 sp3)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: