I have a workbook with several tabs. All are OK apart from one in which the column A is missing. If i insert a new column it just creates a new column B. I cannot scroll any further to the left.
I can however type A1 etc in the name box and the cursor will go there but appears as a very thin vertical line.
Its not really a problem but i am intrigued as to how this could happen or indeed how it can be solved. Thanks
Select whole column from B to the LEFT and right click -> Unhide
No it just wont pick up col A. Incidentaly, if i highlight col b, the name box says "a". It should read B1 etc. Thanks for trying
Check Menu "Window > Unfreeze Panes" to ensure this isn't the problem.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Thanks for the answer. yes it was unfreeze panes, the wife just beat you to it ! Thank you all.
Last edited by VBA Noob; 04-09-2009 at 05:42 PM.
well then
she who must be obeyed knoweth all
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks