"Can't push objects off the sheet"

[Wulf]

Ok, really weird...

I have a worksheet with some 240 columns.

I would VERY much like to be able to reduce their width to below '7', as a GROUP (IE: NOT do it 240 times).

But when I attempt to do so, I get the error "Can't push objects off the sheet".

If I do it individually to SOME, I can. Others, I cannot, and get the error.

I've already checked the File, Options, Advanced, Display options, and "All" is check-marked.

*BUT* (here's the "weird"), if I select a column that was giving me the error, EXPAND it to beyond the 7, go and select any random cell, I can then come back to that column, and it will then magically allow that column to be reduced in width to whatever (5, 4, .6, etc).

What the bleep?!

 

[Peter_SSs]

See if anything here might apply to you.

 

[Wulf]

See if anything here might apply to you.

Yeah, that was one of the sites I had actually looked at, prior to coming here, lol.

Nothing really helped.

What I ended up doing was a bunch of selective "copy"/"paste" steps: Copied values, formulas, formats, etc (almost everything BUT paste "All"), to a different worksheet, and was able to get what I needed done.

Thanks for the reply, though!
Darrell

 

[johnnyL]

Have you tried something like the following? :

Sub ColumnWidthTest()       ' Default = 8.43
'
    Dim wsSource    As Worksheet
'
    Set wsSource = Worksheets("Sheet1")                 ' <--- Set this to the proper sheet name
'
'   Single Range of columns
    wsSource.Range("A:M").ColumnWidth = 5               ' <--- Set this to columns desired as well as the width desired
'
'   Non contiguous column ranges
'    wsSource.Range("A:M, P:Z").ColumnWidth = 5          ' <--- Set this to columns desired as well as the width desired
End Sub

 

[Peter_SSs]

What I ended up doing was a bunch of selective "copy"/"paste" steps: Copied values, formulas, formats, etc (almost everything BUT paste "All"), to a different worksheet, and was able to get what I needed done.

Sometimes that sort of approach is the best way.
Glad you got it going.