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.
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.