View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart Peters Stuart Peters is offline
external usenet poster
 
Posts: 8
Default Hide all columns that span a merged cell?

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.