Unable to hide colums

[warshauer]

Within excel I am able to hide colums to a certain point,
then it tells me cannot shift objects sheet. anyone ever
see this before. I cannot find anything on this.

Thank you

 

[xlhelp]

Excel may be erroneously reporting the used range. I am sure this is going to sound weird, but, select all cells in the worksheet (CTRL/A); go to format, row, autofit and try again.

Else, you may have merged cells on your worksheet. If you don't know if there are, here is a macro to test test for them (courtesy contextures.com)

Sub TestForMergedCells()

Dim AnyMerged As Variant

AnyMerged = ActiveSheet.UsedRange.MergeCells

If AnyMerged = False Then
MsgBox "no merged"
ElseIf AnyMerged = True Then
MsgBox "all merged"
ElseIf IsNull(AnyMerged) Then
MsgBox "mixture"
Else
MsgBox "never gets here--only 3 options"
End If

End Sub

 

[ItIsHardToProgram]

Else
MsgBox "never gets here--only 3 options"
End If

lol...

 

[dcompto]

See if the following helps...

http://experts.about.com/q/Excel-1059/shift-objects-sheet.htm

 

[GlennUK]

Get rid of all cell comments, and then see if you can do it.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[warshauer]

Thanks for all the info,

We will see what happens.