View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default 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.