View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Derk Derk is offline
external usenet poster
 
Posts: 2
Default Macro to Set width of cells

I have a sheet with days of the week in the heading, for a month. I would
like to hide the col if it is a Saturday or Sunday. I am working on trying
to write a macro to check the value of B3 to B34 (which contains the date
and see if it contains Sat or Sun and then set the col width to zero. Thats
the theory, but am stuck with the code required to get the check each cell
then set the width

Thamnks


Derrick