Try

Range("A1").MergeArea.EntireColumn.Hidden = True

Change A1 to the appropriate cell.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Stuart Peters" wrote in
message
...
I have a time sheet that has a date in Row 1 that is a merged
heading of ten
columns. I would like to be able to hide the entire
section(all 10 columns)
of that merged heading.

For instance:
A B C D E F G H I J K
1 4/08/2006
2 d d d d d d d d d d d

Given the date 4/08/2006, I would like to hide all the columns
that compose
that section A through K. L through V would be another
merged column
heading of 4/15/2006.