vba insert X in case of Saturday or Sunday

[max_max]

Hello,
in the attached workbook it is possible to insert a letter X in the range C10:AG10
in case of Saturday (sab-sabato) or Sunday (dom-domenica) in range C8:AG8.
it must be a macro because sometimes the letter X must be entered manually
max

[Arkadi]

Hi max_max,

How about this?

Please Login or Register  to view this content.

[Marc L]

As a beginner starter :

Sub Demo() 
    [C10:AG10].Formula = "=IF(WEEKDAY(C8,2)=6,""X"","""")" 
    [C10:AG10].Formula = [C10:AG10].Value2 
End Sub  

Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

[max_max]

Hi arkadi your macro work well.
I have modified with selectionchange:

Please Login or Register  to view this content.

but non work this:

Dim ws As Worksheet

Range("C10:AG10").Select
Selection.ClearContents

Set ws = ThisWorkbook.Worksheets("CONF")

[Marc L]

Remove any Select & Selection, just directly work on objects !

Copy my code to the Foglio3(CONF) worksheet module and see how it works !
Update formula with >5 instead of =6, at bambino level ‼

[max_max]

hi arkadi:
I can't add other X letters besides the macro ones

Please Login or Register  to view this content.

------------------------------------------------------------------------------------------------------------------------

hi marcL:
I can't add other X letters besides the macro ones

Please Login or Register  to view this content.

max

[Arkadi]

My code (even converted to selection change), would not stop manual "X", but you are adding a line that removes ALL "X":

Please Login or Register  to view this content.

Maybe you need code that when your cell C3 (I think it was C3?) changes dates, then you clear that range, but not on "selection change" since that means every time you select any cell, all X's are removed and then only Sat/Sun will have X again.

[max_max]

At every change of month, the X of Saturdays and Sundays must change
but having a chance to add other X manuals (monthly holidays)

[max_max]

Hi arkadi and marcL I removed selectionchange and left the macros

Please Login or Register  to view this content.

Please Login or Register  to view this content.

They work well
max

[Marc L]

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED.

Also,you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner
of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[max_max]

Hi marcL and arkadi I waited this morning to try the macros in the office and both work.
Thanks again to everyone.
max