Spriglet #9: Conditionally hide columns in Excel using VB

I have time tracking worksheet that I use at work. It looks something like this:

Task Total Hours Friday, 9/7/2007 Saturday, 9/8/2007
Status Report 5.25 1.5 0
Staff Meeting 12.5 1.5 0

Since I don’t work on Saturday or Sunday, I’d like to hide all columns that have a date that’s a Saturday or Sunday.

Here’s a little VB macro that will do the trick:

h/t Rowan

(Visited 20 times, 1 visits today)
Notify of
Inline Feedbacks
View all comments