Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel - Clear fields based on date 1
- Thread starter 5656
- Start date
What are the fields being designated by?? Brainbench MVP for Microsoft Word
techsupportgirl@home.com
techsupportgirl@home.com
- Thread starter
- #3
-
1
- #4
Hello, 5656.
Suppose the range of fields you want to clear is B2:B3 for instance, and you want to have it clear on Sunday when the workbook is opened but not on the other days, a possible solution is as follows.
[1] Create a macro named Aut
pen(). The name as such is a requirement.
[2] Edit the macro :
Sub Autpen()
If WeekDay(Now()) = 1 Then '1 for Sunday
Range("B2:B3".ClearContents
End If
End Sub
[3] Range ("B2:B3" and day-of-week (1 for Sunday, 2 for Monday etc) are parameters you have to adapt to your worksheet structures and timing requirement.
[4] The macro will be auto-executed once the workbook is open and does the job as described.
regards - tsuji
Suppose the range of fields you want to clear is B2:B3 for instance, and you want to have it clear on Sunday when the workbook is opened but not on the other days, a possible solution is as follows.
[1] Create a macro named Aut
pen(). The name as such is a requirement.[2] Edit the macro :
Sub Aut
pen()If WeekDay(Now()) = 1 Then '1 for Sunday
Range("B2:B3"
.ClearContentsEnd If
End Sub
[3] Range ("B2:B3"
and day-of-week (1 for Sunday, 2 for Monday etc) are parameters you have to adapt to your worksheet structures and timing requirement.[4] The macro will be auto-executed once the workbook is open and does the job as described.
regards - tsuji
- Status