Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: column A is missing. not hidden.

  1. #1
    Board Regular
    Join Date
    Aug 2006
    Location
    Australia
    Posts
    268
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default column A is missing. not hidden.

    i've come across something very odd on a worksheet i've inherited.

    column A is missing.

    it is not hidden. i have highlighted all and done 'unhide' columns. nothing.

    it is not tiny. i have highlighted all and done 'column width' = 10. nothing.

    i know it's there... if i put my cursor into B1 and press the left arrow, the cursor moves to A1, i can just see the blinking end of the cursor and can make changes to data in the column A cells.

    where did it go?!?

  2. #2
    MrExcel MVP mikerickson's Avatar
    Join Date
    Jan 2007
    Location
    Davis CA
    Posts
    21,200
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    My guess is that some how the scroll area got set so you can't scroll there.

    Worksheets("sheetName").scrollArea=""

    should set things right.

  3. #3
    Board Regular
    Join Date
    Aug 2006
    Location
    Australia
    Posts
    268
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ah. hadn't thought of that... but, there were no macros/code in this file before i got my hands on it.

    tried adjusting the scroll area as suggested just in case it was 'left over' somehow, but to no avail.

  4. #4
    MrExcel MVP mikerickson's Avatar
    Join Date
    Jan 2007
    Location
    Davis CA
    Posts
    21,200
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try copying the sheet and pasting it into another (new, dumpable) workbook.

  5. #5
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,108
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    From your worksheet menu click on Window > Unfreeze Panes.

    Then select any cell and hit the Home key.

  6. #6
    Board Regular
    Join Date
    Aug 2006
    Location
    Australia
    Posts
    268
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ha. brilliant. that was much too simple... why didn't i think of it!

  7. #7
    Board Regular
    Join Date
    Apr 2002
    Location
    London, England.
    Posts
    257
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: column A is missing. not hidden.

    Even ten years after this question was posed, these answers are still helping, it worked for me.
    Many thanks

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
  •  


DMCA.com