Unable to set columns hidden

I am not sure that this is the right place although my spreadsheet is run with VBA, but I have a spreadsheet that I routinely have columns P through XFD hidden since they are outside scope of my worksheet. For some reason, I found that I can no longer set the entire range hidden. After troubleshooting, I found I could hide columns P through T and columns AA through XFD. Columns U,V,W,X,Y,Z will not allow me to hide them. I have selected them at the top of the columns and pressed the Delete key, but still unable to hide them. Changed the format on those columns to General, selected again and pressed the Delete key, but still unable to hide them.

Does anyone have any idea what may be happening, or a routine that can run from top to bottom of these columns to ensure everything is cleared?

Any help or suggestions would be greatly appreciated.

Thank you

Thank you but I tried this, and it does not work. I have found that I can manually select columns and then right click to get the column menu and then select high and it works. However, if I try to select all columns to the end I get the following error: "Can't push objects off the sheet"?

Are you able to post the workbook?

Hi dentler,
first of all make a copy of the file.
I am attaching a macro that will search for objects. Both hidden and miniature ...
If it finds something, it will prompt you to confirm the deletion of the object.

Please Login or Register  to view this content.

m.s.

Thank You. I will give it a try.