Hiding columns in VB

  • Thread starter Thread starter Rick B
  • Start date Start date
R

Rick B

Trying to hide columns within my code and I am getting the
error "Unable to set the hidden property", when trying to
manually hide them within Excel I get the error "Cannot
shift objects off sheet".

There are merged cells within the range, however I get the
same error, even if I unmerge them. This is a very large
workbook, and this particular sheet is no exception.
 
You probably have something using all the columns.
use ctrl/end to find your last. Delete unneeded rows/columns and SAVE.
 
Nope, I unprotect before hiding/unhiding columns in the
code. It was also unprotected when I tried to manually do
it in Excel.
 
Found it. There were cells that had comments, and the
properties were set to "Don't move or size with cells".
First time I have ever run into that problem.

Thanks for the help.

Rick
 
Back
Top