Hide cells using an IF function

you mean like this?

Please Login or Register  to view this content.

ok
Right Click on Sheet Tab Name and Click View Code and paste this below into that module.

Please Login or Register  to view this content.

Originally Posted by a13ks

.....for instance when I type in a date and it returns either a Saturday or Sunday the cells do not clear......

Do you want the cells to clear or rows to hide?

You can use a VBA IIF statement to hide or un-hide rows as well.
Something like this in the worksheet module.
Is Range("D3") being changed with a formula? if so we would have to use worksheet calculate I suppose.

Here is the worksheet change code.

Please Login or Register  to view this content.

Attach a simple sample if you have to.

More info on VBA IIF Statement.
http://www.davesexcel.com/apps/blog/...atement-in-vba

Try this instead, it looks like D2 is the cell that will be manually entered on the worksheet.

Please Login or Register  to view this content.

It does work, when I change the date in D2 the rows hide and unhide.

Signing off for now, going Christmas shopping!!!

@ davesexcel: It is really nice to learn about the IIF function....this is actually my first time of doing it. But below is my code using only the "If" function and it works.

Please Login or Register  to view this content.