Hi guys,
sorry again for a simple question but I cant seem to get it to work.
If Weekday(rngCel) = 1 Then rngCel.Offset(0, 1).Value = 45
.NumberFormat = "0.00"
If Weekday(rngCel) = 1 Then rngCel.Offset(0, 1).Value = Format(45, "Currency")
I have tried with this...