hide collumn function is giving error message
 

Hi,
running macros which hide certain collumns.
Been running them fine for quite a while.
Now it`s giving an error message "Cannot shift objects off sheet" ??
Try to debug but nothing wrong: in fact even if I just try to hide these
collumns manually I get the same message.
I`ve reset collumn widths recnetly but nothing else.
I have macro buttons at top of some of the collumns but they`ve given me no
problems before.
Any ideas guys?
Thanks
RR1

hide collumn function is giving error message
 

Check for any merged cells across columns??

If this post helps click Yes
---------------
Jacob Skaria


"Romileyrunner1" wrote:

Hi,
running macros which hide certain collumns.
Been running them fine for quite a while.
Now it`s giving an error message "Cannot shift objects off sheet" ??
Try to debug but nothing wrong: in fact even if I just try to hide these
collumns manually I get the same message.
I`ve reset collumn widths recnetly but nothing else.
I have macro buttons at top of some of the collumns but they`ve given me no
problems before.
Any ideas guys?
Thanks
RR1