"Max" wrote:

Apologies for the unintentioned garble ..:

Here's a re-post:

Taken from a recent Dave Peterson post:

Could it be:

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;en-ca;211769

do you have shapes/comments on your worksheet?

and another link:
http://google.com/groups?threadm=1c4...280a %40phx.g
bl


--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----

Thanks Max
Sorry it did not work.there are no sahapes nor any comment
my data is as follow
column1 to 12 contains July04 -Jun05 (sales figures for product1) &
subtotal in column 13...this process continues for 20 such products
When I want to update sales figures for Nov 04 I hide all columns except
for Nov 04 for all products. When I try doing the above I am able to hide a
only some of the columns & rest it stops giving a message "cannnot shift
objects off sheet"
Appreciate your help

Thanks
varun