column A is missing. not hidden.

[cmhoz]

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?!?

 

[mikerickson]

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

Worksheets("sheetName").scrollArea=""

should set things right.

 

[cmhoz]

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.

 

[mikerickson]

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

 

[Tom Urtis]

From your worksheet menu click on Window > Unfreeze Panes.

Then select any cell and hit the Home key.

 

[cmhoz]

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

 

[Mike54]

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

 

[e3wilson]

From your worksheet menu click on Window > Unfreeze Panes.

Then select any cell and hit the Home key.

THANK YOU SOOOOO MUCH TOM!!! This worked perfectly!

 

[everestto]

From your worksheet menu click on Window > Unfreeze Panes.

Then select any cell and hit the Home key.

11 years later, this is still helping. Thank you, Tom.

 

[tasos8282]

12 years and probably some excel versions later, still working....many many thanks!