Cannot hide columns in Excel

J

John Johns

I find the following error message whenever I try to hide certain columns in
one
of my excel workbooks (through macro).
"Unable to set the Hidden Property of the Range Class. Error=1004"
This happens after hiding a few columns. When I try further to hide
manually, the
error message is
"Cannot shift objects off sheet"
and I cannot hide. Can sombody please help me to (e-mail address removed) ?
 
C

CLR

First, I would try to run the file on another computer to isolate is the
trouble is within the file itself, or within your installation of Excel.

HTH
Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide columns based on row values 2
Grouping columns - error message 2
Hiding Column Issue 1
hide collumn function is giving error message 1
I CANNOT HIDE COLUM & I GOT ERROR MASSAGE "CANNOT SHIFT PBJECTS O. 1
protecing hidden columns 1
Hiding Columns produces error <----HELP PLEASE 2
Cannot shift objects off sheet 2

Top