(Msg. 1) Posted: Tue Sep 08, 2009 2:55 am
Post subject: gettin an error "Cannot shift objects off sheet" while filtering Archived from groups: microsoft>public>excel>crashesgpfs (more info?)
Am getting an error of "Cannot shift objects off sheet" while filtering
data.....What is wrong with that can anyone explain....Also is filtering
limited to no. of rows/columns???
(Msg. 2) Posted: Thu Sep 10, 2009 11:31 am
Post subject: RE: gettin an error "Cannot shift objects off sheet" while filtering [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi
Try this in each sheet
Sub Macro7() 'will move objecter if row/colm can not be hide.
Dim s As Shape
On Error Resume Next
For Each s In ActiveSheet.Shapes
s.Placement = xlMoveAndSize
Next
End Sub
"Shalin" wrote:
> Am getting an error of "Cannot shift objects off sheet" while filtering
> data.....What is wrong with that can anyone explain....Also is filtering
> limited to no. of rows/columns???
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office