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