Remove Columns

[AlexanderBB]

One of my worksheets stops at column "Z" and there's nothing to the right of it.
How did I do this ? Can't remember and can't find how from Google.
Thanks.

 

[AlexanderBB]

range("a:xfd").entirecolumn.hidden=false
and Enter.
That brings up error "Application defined of object-defined error"

Dante I select all the cells, then a right click (otherwise selection is gone) the menu has no "Show"

 

[DanteAmor]

range("a:xfd").entirecolumn.hidden=false
and Enter.
That brings up error "Application defined of object-defined error"

Dante I select all the cells, then a right click (otherwise selection is gone) the menu has no "Show"

You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

 

[AlexanderBB]

That was a good idea Dante.. here goes
https://www.dropbox.com/s/3o60n8mr3vrujba/Demov5.xlsx?dl=0

 

[DanteAmor]

That was a good idea Dante.. here goes

You needed to change the width of columns as I mentioned in post#3

Maybe you changed the width of columns. Select all the cells, change the column width to 10.

Select all the cells, click on any column, select from popup menu Column Witdh, write 10, press Ok.

 

[Rick Rothstein]

Dante I select all the cells, then a right click (otherwise selection is gone) the menu has no "Show"

You do not right click the selection... you right click any letter in the column header (the part of the worksheet with the A, B, C, etc. on it.)

 

[AlexanderBB]

This is becoming weird... No columns need change their widths (the widths are correct). I wanted to know how the columns become restricted to "Z".

>Select all the cells, click on any column, select from popup menu Column Witdh, write 10, press Ok.
If I select all the cells and click a column, it all becomes not selected, if I right click a menu appears but there is no "Column Widths" option.

 

[AlexanderBB]

Oh Cricky thanks Rick.. that's undone whatever it was, but how does it get like it was ?

 

[Rick Rothstein]

Oh Cricky thanks Rick.. that's undone whatever it was, but how does it get like it was ?

That... I do not know. I mean I do know how to do it (select a column, with the Shift key pressed press the End key followed by the Right Arrow key, then right click a column header letter and select Hide from the popup menu), but it is hard to believe you did it without knowing that you did it.

 

[AlexanderBB]

Cool, thanks Rick, and the others (Sorry I didn't follow what you meant). I would have know how at the time but it may have been 5 years ago!
LOL pretty simple when you know.... thanks again.

 

[DanteAmor]

Cool, thanks Rick, and the others (Sorry I didn't follow what you meant). I would have know how at the time but it may have been 5 years ago!
LOL pretty simple when you know.... thanks again.

You just had to put a new column width to all the columns, that will show all the columns.
As I commented from post #3


But hey, the important thing is that you already have all your columns.

I'm glad to help you. Thanks for the feedback.