Grouping and Objects

K

Kevin H. Stecyk

Hi,

I inherited a spreadsheet. When I group certain rows, I get the message,
"Cannot shift objects off sheet." As far as I can tell, there are no
objects in the rows. I can group other rows in the same sheet without
difficulty, but some rows I can't.

Is there a way for me to see what Excel is complaining about?

I am using XL 2003.

Thank you.

Best regards,
Kevin
 
K

Kevin H. Stecyk

Dave Peterson wrote...
maybe this'll help:

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default.aspx?scid=kb;en-ca;211769
Click to expand...

Hi Dave,

I used the macro suggested in the article...

Sub Test()
Dim s As Shape
On Error Resume Next
For Each s In ActiveSheet.Shapes
s.Placement = xlMoveAndSize
Next
End Sub

Problem solved. I didn't find the problem object, but the problem is fixed.

Thank you!

Regards,
Kevin
 
Top