How to Unhide and Use Columns to the right of the worksheet

[Sharat Chandrasekhar]

I wanted to hide columns AP and everything to the right of it in my
worksheet. So I selected column AP hit CTRL-SHIFT-RIGHT KEY and I
could confine the visible area of my worksheet to A-AO

So far so good.

I now want to be able to insert columns between A and AO.

I get a message saying that it cant shift non-blank columns off the
worksheet (which is now supposedly confined to A-AO.

I inserted the line

ActiveSheet.Range("AP1:AZ1").EntireColumn.Hidden = False

in my Worksheet_SelectionChange macro and found that only column AP
was visible, but that I couldnt select it. I still cant insert columns
anywhere.

Also, for some reason, I cant select an entire row!!!

Any ideas on how to proceed?

Many thanks in advance

-Sharat

 

[Ron de Bruin]

Hi Sharat

I get a message saying that it cant shift non-blank columns off the
worksheet (which is now supposedly confined to A-AO.

Then you have data in the last column.(256)

Or

Excel can think that the usedrange is bigger then it is.

You can see how big your usedrange is on every sheet with CTRL-END
If the row/column is not the last row/column with data then:

1 Select the first row below your last row with data
2 CTRL-SHIFT-DOWN ARROW
3 Right click on the selection and choose delete

And then for the columns

1 Select the first column next to your last column with data
2 CTRL-SHIFT-RIGHT ARROW
3 Right click on the selection and choose delete

Save the file an close it

Try this and see if it solved your problem

 

[Sharat Chandrasekhar]

Ron,

Thanks for your suggestion. Actually, just closing the file and
re-opening it seemed to work!