Hiding columns in VB

[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.

 

[Don Guillett]

You probably have something using all the columns.
use ctrl/end to find your last. Delete unneeded rows/columns and SAVE.

 

[Rick B]

No such luck. The last column used is HA, and Ctrl+End
returns the same column.

 

[Don Guillett]

Is the sheet protected? If so, try unprotecting first.

 

[Rick B]

Nope, I unprotect before hiding/unhiding columns in the
code. It was also unprotected when I tried to manually do
it in Excel.

 

[Don Guillett]

are you speficing the sheet?
Post code.

 

[Rick B]

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