Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: "Cannot Shift Objects Off Sheet" Error

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    M&T Bank
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm trying to hide columns in a spreadsheet, but I keep getting the error "Cannot Shift Objects Off Sheet". I've deleted all columns to the right and rows below the data and saved the file, but the error keeps popping up.

    Why would objects be shifted off the sheet when I HIDE a column?

    Any suggestions or solutions?

    Thanks.

    Denise

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It sounds odd, sounds more like you're inserting a column. If you're using vba, are using something like:

    Columns("J:L").EntireColumn.Hidden = True

    Regards, Nate

    [ This Message was edited by: NateO on 2002-02-28 10:44 ]

  3. #3
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You probably have some shape / object
    Check to see if you have any....including
    Comments. If you do then just change the shapes property to Move & size with cell.

    Just as a side note Comments are a part of the
    shapes collection....so you don't neccessarily have to have the Box you can change this to any shape you want.



    HTH
    Ivan

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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