Hiding columns in VB
 

Trying to hide columns within my code and I am getting the
error "Unable to set the hidden property", when trying to
manually hide them within Excel I get the error "Cannot
shift objects off sheet".

There are merged cells within the range, however I get the
same error, even if I unmerge them. This is a very large
workbook, and this particular sheet is no exception.

Hiding columns in VB
 

You probably have something using all the columns.
use ctrl/end to find your last. Delete unneeded rows/columns and SAVE.

--
Don Guillett
SalesAid Software

"Rick B" wrote in message
...
Trying to hide columns within my code and I am getting the
error "Unable to set the hidden property", when trying to
manually hide them within Excel I get the error "Cannot
shift objects off sheet".

There are merged cells within the range, however I get the
same error, even if I unmerge them. This is a very large
workbook, and this particular sheet is no exception.

Hiding columns in VB
 

No such luck. The last column used is HA, and Ctrl+End
returns the same column.


-----Original Message-----
You probably have something using all the columns.
use ctrl/end to find your last. Delete unneeded
rows/columns and SAVE.

--
Don Guillett
SalesAid Software

"Rick B" wrote in
message
...
Trying to hide columns within my code and I am getting
the
error "Unable to set the hidden property", when trying
to
manually hide them within Excel I get the error "Cannot
shift objects off sheet".

There are merged cells within the range, however I get
the
same error, even if I unmerge them. This is a very
large
workbook, and this particular sheet is no exception.




.

Hiding columns in VB
 

Is the sheet protected? If so, try unprotecting first.

--
Don Guillett
SalesAid Software

"Rick B" wrote in message
...
No such luck. The last column used is HA, and Ctrl+End
returns the same column.


-----Original Message-----
You probably have something using all the columns.
use ctrl/end to find your last. Delete unneeded
rows/columns and SAVE.

--
Don Guillett
SalesAid Software

"Rick B" wrote in
message
...
Trying to hide columns within my code and I am getting
the
error "Unable to set the hidden property", when trying
to
manually hide them within Excel I get the error "Cannot
shift objects off sheet".

There are merged cells within the range, however I get
the
same error, even if I unmerge them. This is a very
large
workbook, and this particular sheet is no exception.




.

Hiding columns in VB
 

Nope, I unprotect before hiding/unhiding columns in the
code. It was also unprotected when I tried to manually do
it in Excel.


-----Original Message-----
Is the sheet protected? If so, try unprotecting first.

--
Don Guillett
SalesAid Software

"Rick B" wrote in
message
...
No such luck. The last column used is HA, and Ctrl+End
returns the same column.


-----Original Message-----
You probably have something using all the columns.
use ctrl/end to find your last. Delete unneeded
rows/columns and SAVE.

--
Don Guillett
SalesAid Software

"Rick B" wrote in
message
...
Trying to hide columns within my code and I am
getting
the
error "Unable to set the hidden property", when
trying
to
manually hide them within Excel I get the
error "Cannot
shift objects off sheet".

There are merged cells within the range, however I
get
the
same error, even if I unmerge them. This is a very
large
workbook, and this particular sheet is no exception.




.



.

Hiding columns in VB
 

are you speficing the sheet?
Post code.

--
Don Guillett
SalesAid Software

"Rick B" wrote in message
...
Nope, I unprotect before hiding/unhiding columns in the
code. It was also unprotected when I tried to manually do
it in Excel.


-----Original Message-----
Is the sheet protected? If so, try unprotecting first.

--
Don Guillett
SalesAid Software

"Rick B" wrote in
message
...
No such luck. The last column used is HA, and Ctrl+End
returns the same column.


-----Original Message-----
You probably have something using all the columns.
use ctrl/end to find your last. Delete unneeded
rows/columns and SAVE.

--
Don Guillett
SalesAid Software

"Rick B" wrote in
message
...
Trying to hide columns within my code and I am
getting
the
error "Unable to set the hidden property", when
trying
to
manually hide them within Excel I get the
error "Cannot
shift objects off sheet".

There are merged cells within the range, however I
get
the
same error, even if I unmerge them. This is a very
large
workbook, and this particular sheet is no exception.




.



.

Hiding columns in VB
 

Found it. There were cells that had comments, and the
properties were set to "Don't move or size with cells".
First time I have ever run into that problem.

Thanks for the help.

Rick
-----Original Message-----
Is the sheet protected? If so, try unprotecting first.

--
Don Guillett
SalesAid Software

"Rick B" wrote in
message
...
No such luck. The last column used is HA, and Ctrl+End
returns the same column.


-----Original Message-----
You probably have something using all the columns.
use ctrl/end to find your last. Delete unneeded
rows/columns and SAVE.

--
Don Guillett
SalesAid Software

"Rick B" wrote in
message
...
Trying to hide columns within my code and I am
getting
the
error "Unable to set the hidden property", when
trying
to
manually hide them within Excel I get the
error "Cannot
shift objects off sheet".

There are merged cells within the range, however I
get
the
same error, even if I unmerge them. This is a very
large
workbook, and this particular sheet is no exception.




.



.