| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ASC() does not convert full-width to half-width letters (Exel 2003 | Excel Worksheet Functions | |||
| Macro for column width | Excel Discussion (Misc queries) | |||
| HOW DO I CHANGE THE WIDTH OF ONLY A FEW CELLS | Excel Discussion (Misc queries) | |||
| How do I change the width of some cells but not others? | Excel Worksheet Functions | |||
| Getting Column width using macro.. | Excel Programming | |||
Threaded Mode
