From Excel, I can hide a single column even if it crosses merged cells,
without hiding all of the cells included in the merged set of cells. If I
hide the column with a macro, all of the columns in the merged set of cells
are hidden. How can I get the single column to be hidden without a lot of
unmerging and remerging of cells?
David Lloyd - 10 Dec 2005 00:20 GMT
One alternative is to set the ColumnWidth property to zero. For example:
Columns("B:B").ColumnWidth = 0
If you want to unhide the column, you can resort back to the Hidden
property, or change the ColumnWidth property again.

Signature
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or warranties.
From Excel, I can hide a single column even if it crosses merged cells,
without hiding all of the cells included in the merged set of cells. If I
hide the column with a macro, all of the columns in the merged set of cells
are hidden. How can I get the single column to be hidden without a lot of
unmerging and remerging of cells?
ZipCurs - 12 Dec 2005 19:46 GMT
That did the job. I thought I had tried that, but apparently not!
> One alternative is to set the ColumnWidth property to zero. For example:
>
[quoted text clipped - 8 lines]
> are hidden. How can I get the single column to be hidden without a lot of
> unmerging and remerging of cells?
Pat Hartman(MVP) - 10 Dec 2005 06:01 GMT
Tables are not spreadsheets. They do not have cells and they work nothing
like spreadsheets. It's time to put on your relational database hat and use
database techniques to control the view of data rather than spreadsheet
techniques. One thing that seems to cause a lot of confusion is the fact
that in a spreadsheet the data and presentation layers are combined. That
means that the format of a spreadsheet dictates how data is stored. With a
database, data and presentation are completely separate. Tables store data.
Forms and reports display it.
> From Excel, I can hide a single column even if it crosses merged cells,
> without hiding all of the cells included in the merged set of cells. If I
> hide the column with a macro, all of the columns in the merged set of
> cells
> are hidden. How can I get the single column to be hidden without a lot of
> unmerging and remerging of cells?
David C. Holley - 10 Dec 2005 07:02 GMT
This is a newsgroup for ACCESS only.
> From Excel, I can hide a single column even if it crosses merged cells,
> without hiding all of the cells included in the merged set of cells. If I
> hide the column with a macro, all of the columns in the merged set of cells
> are hidden. How can I get the single column to be hidden without a lot of
> unmerging and remerging of cells?