Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Nov 2001
    Location
    Carson City, Nevada, USA
    Posts
    46
    Thanks
    2
    Thanked 0 Times in 0 Posts

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

    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

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

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

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

    Steve

  3. #3
    Lounger
    Join Date
    Nov 2001
    Location
    Carson City, Nevada, USA
    Posts
    46
    Thanks
    2
    Thanked 0 Times in 0 Posts

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

    Thnks Steve,

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

    Robbie

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •